0

I have a table of projects with two of it's columns as 'language' and 'tag'.

After the user gives an input, I want to output all the projects whose language is input or tag is input.

Sql query for above would be this,

Sql query: Select * from TableName where language='input' OR tag='input'

I tried to execute the same in Gql but in vain. What should be the query in Gql to output the data in the above mentioned way.

Wasim Thabraze
  • 780
  • 1
  • 12
  • 29

2 Answers2

1

GQL doesn't have OR, so basically you have to make two separate queries and union results:

Select * from TableName where language='input'
Select * from TableName where tag='input'

You should join results on your app side, Cloud Console doesn't support such things too.

See GQL reference: https://cloud.google.com/datastore/docs/apis/gql/gql_reference

Igor Artamonov
  • 35,450
  • 10
  • 82
  • 113
1

I don't know if is mandatory for you to use GQL, but in case you are able to avoid it, you can use the ndb filter instead. 

results = TableName.query(ndb.OR(TableName.language == 'input',
                       TableName.tag == 'input'))
for result in results: 
    ....your code here...

More information in: https://cloud.google.com/appengine/docs/python/ndb/queries

Pere Martra
  • 36
  • 7