GQL query with numeric id in datastore viewer

google-app-engine gql
Pawel Markowski picture Pawel Markowski · Oct 6, 2010 · Viewed 13.3k times · Source

I want to build GQL query to get an object using its numeric id. I'm doing this in Datastore viewer in App management console, so I can't use Model.get_by_id(numeric_id). Something like

SELECT * FROM Model WHERE id = <numeric_id>

also doesn't work.

Answer

Saxon Druce picture Saxon Druce · Oct 6, 2010

Try this:

SELECT * FROM Model where __key__ = KEY('Model', <numeric_id>)

Related questions

Google App Engine: Is it possible to do a Gql LIKE query?

Simple one really. In SQL, if I want to search a text field for a couple of characters, I can do: SELECT blah FROM blah WHERE blah LIKE '%text%' The documentation for App Engine makes no mention of …

Read More
How do I query in GQL using the entity key

How do I write a query against the entity key using GQL in the Google App Engine Data Viewer ? In the viewer, the first column (Id/Name) displays as name=_1, in the detail view it shows the key as Decoded …

Read More
What's the best way to count results in GQL?

I figure one way to do a count is like this: foo = db.GqlQuery("SELECT * FROM bar WHERE baz = 'baz') my_count = foo.count() What I don't like is my count will be limited to 1000 max and my query will …

Read More