I have entry in the Order table with the value (id=5629499534213120) in the Name/ID column. I want to search for the Order entries using this field. I tried executing the following query, it is not giving any result.
SELECT * from Order where __key__ = KEY(Order, 5629499534213120) I am getting the following error. 'SELECT * from Order where __key__ = KEY(Order, 5629499534213120) LIMIT 50': Encountered "Order" at line 1, column 15. Was expecting one of: <UNQUOTED_NAME> ... <QUOTED_NAME> ... Can you please let me know the correct query. Also, I need to find the child items (OrderItem) for the given order. SELECT * FROM OrderItem WHERE __key__ HAS ANCESTOR KEY(Order, 5629499534213120) for this query, i getting the error, 'SELECT * FROM OrderItem WHERE __key__ HAS ANCESTOR KEY(Order, 5629499534213120) LIMIT 50': Encountered "Order" at line 1, column 56. Was expecting one of: <UNQUOTED_NAME> ... <QUOTED_NAME> ... please help. Thanks -- You received this message because you are subscribed to the Google Groups "Google App Engine" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at http://groups.google.com/group/google-appengine. To view this discussion on the web visit https://groups.google.com/d/msgid/google-appengine/bb0400d0-d9f7-475e-b437-f32ea9dd4bc6%40googlegroups.com. For more options, visit https://groups.google.com/d/optout.
