GQL（Google 应用引擎）中的 OR 条件返回错误为什么？

发布于 2024-11-12 16:49:33 字数 205 浏览 5 评论 0原文

当我在 GQL 中使用 OR 条件时，它返回错误消息“BadQueryError：解析错误：符号 OR 处没有其他符号。为什么？

db.GqlQuery("Select * from vendor where access='public' OR organisation_id='"+ orgid +"'")

原文

When i use the OR condion in GQL it return error messege tht "BadQueryError: Parse Error: Expected no additional symbols at symbol OR . Why?

db.GqlQuery("Select * from vendor where access='public' OR organisation_id='"+ orgid +"'")

分享到QQ

分享到微博

如果你对这篇内容有疑问，欢迎到本站社区发帖提问参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。

发布评论

需要登录才能够评论，你可以免费注册一个本站的账号。

墨小沫ゞ 2024-11-19 16:49:33

    GQL does not have an OR operator. However, it does have an IN operator, 
which provides a limited form of OR.

文档清楚地表明 GQL 没有 OR 运算符..

您可以执行类似的操作..进行两个查询并合并结果...

  vendors=vendor.all()
  pub_vendors = vendors.filter("access = ","public")
  vendors=vendor.all()
  org_vendors = vendors.filter("organisation_id = ",orgid)
  results = pub_vendors.extend(org_vendors)

    GQL does not have an OR operator. However, it does have an IN operator, 
which provides a limited form of OR.

Docs clearly says that GQL doesn't have an OR operator..

You could do something like this ..Make two queries and combine the results...

  vendors=vendor.all()
  pub_vendors = vendors.filter("access = ","public")
  vendors=vendor.all()
  org_vendors = vendors.filter("organisation_id = ",orgid)
  results = pub_vendors.extend(org_vendors)

回复收藏 0 原文

~没有更多了~