GQL query with numeric id in datastore viewer

Unfortunately, there does not appear to be a way to write a query equivalent to

SELECT * FROM Model WHERE id = <numeric_id>

which would select all Model entities with the given id. If you're ok with something equivalent to

SELECT * FROM Model WHERE id = <numeric_id> AND parent IS NULL

you can use something like

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

If your entity does have a parent though, you'll need to specify that as part of the key, like

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

If the parent itself has a parent, you'll need to specify that too. (Grandparent goes left of the parent, and so on.)

Of course if you're not restricted to GQL (like if you're using Python, Go, or Java), you can query the keys, decode them and filter by id, then fetch the corresponding entities. But of course that doesn't work in the Datastore Viewer since you can only use GQL.


Another way around is, first get the key for the entity using the id by

key = db.Key.from_path('Model', int(id))

then get the object by

obj = db.get(key)

The advantage is, you do not have to do any string formatting.

reference: problem set 3 at this course, https://classroom.udacity.com/courses/cs253/


Try this:

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