Query all Children for Parent using Appengine Admin Console Datastore Viewer

Question

I have an Entity named RouteCompletion that identifies Route as it's Parent (using Objectify @Parent annotation).

In the AppEngine Admin Console I am able to query for the specific child by writing a standard key query.

SELECT * FROM RouteCompletion where __key__ = Key('Route',5704906207920128,'RouteCompletion','gc-136985405')

returns the expected result:

I would like to find all children for that same Parent. I tried:

SELECT * FROM RouteCompletion where __key__ = Key('Route',5704906207920128)

The query is valid GQL, but returns no results.

score 4 · Answer 1 · edited May 15 '17 at 00:54

4

Use has ancestor instead of =.

SELECT * FROM RouteCompletion where __key__ has ancestor Key(Route,5704906207920128)

edited May 15 '17 at 00:54

Pang

answered May 12 '17 at 08:45

Razvan

score 0 · Accepted Answer · edited May 15 '17 at 00:55

0

SELECT * FROM RouteCompletion where ANCESTOR is Key('Route',5704906207920128)

edited May 15 '17 at 00:55

Pang

answered May 25 '14 at 09:29

Aaron Roller

1

doesn't work. I get: GQL query error: Encountered "ancestor" at line 1, column 34. Was expecting one of: "false", "null", "true", , , , , , , , – bgenchel Jul 08 '16 at 00:40

2 Answers2