How to search in the GQL Viewer in appengine dashboard by key?

Question

I use this and it gives an error:

SELECT * FROM Cache where __key__ = KEY('Cache', 'ag9wYWdhbGd1eS1zdGF0aWNyHAsSBUNhY2hlIhEvYnV0dG9ucy9lZGl0LmdpZgw ')

Duplicate of: http://stackoverflow.com/questions/1998084/how-do-i-query-in-gql-using-the-entity-key/1999747#1999747 — Adam Crossland, Feb 03 '10 at 20:26

score 1 · Accepted Answer · answered Feb 03 '10 at 14:17

1

You're passing in what looks like an encoded key as a key name. Try "KEY('ag9wYWdhbGd1eS1zdGF0aWNyHAsSBUNhY2hlIhEvYnV0dG9ucy9lZGl0LmdpZgw')" instead.

answered Feb 03 '10 at 14:17

Nick Johnson

I tried this as well. It works fine in the code but doesn't work in the GQL Dashboard. Any suggestions? – GeekTantra Feb 04 '10 at 04:27

score 0 · Answer 2 · answered Mar 02 '11 at 02:43

0

It seems to be important to use single quotes. This seems to work:

SELECT * FROM Cache where __key__ = KEY('ag9wYWdhbGd1eS1zdGF0aWNyHAsSBUNhY2hlIhEvYnV0dG9ucy9lZGl0LmdpZgw ')

answered Mar 02 '11 at 02:43

Chris

2 Answers2