GQL Projection Query on Embedded Entity

Question

Say I have a User entity with an embedded entity address which contains a house number property and a street property. How can I write a GQL projection query that will filter based on name and return a list of addresses ?

Sample Data:

The projection query I am trying to write:

SELECT address FROM User WHERE name = Bob

This should return two addresses but it returns no results.

Thanks to anyone who answers !

score 3 · Accepted Answer · answered Nov 10 '16 at 00:23

3

You can't project the entire entity value, but you can project the individual properties in the entity value, e.g.:

SELECT address.houseNumber FROM User WHERE name = Bob

answered Nov 10 '16 at 00:23

Ed Davisson

2,927
11
11

What would be the best way to get the entire entity value ? Do I just project all the individual properties separately and combine them together afterwards ? – Kookz Nov 10 '16 at 00:50
Either that or use a regular (non-projection) query. – Ed Davisson Nov 11 '16 at 21:18
@EdDavisson, what would be an example of a regular (non-projection) query? – MauroPorras Nov 14 '18 at 21:10
`SELECT * FROM User WHERE name = Bob` – Ed Davisson Nov 15 '18 at 17:05

GQL Projection Query on Embedded Entity

1 Answers1