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