GQL not working when I select a particular field

Question

I have an entity called with columns app, id, params, view, timestamp. When I do a select * in GQL it works fine. Screenshot attached below.

enter image description here

However when I try to select only one column I don't see any results. Screenshot attached below.

enter image description here

Also when I try to apply a where clause again I don't see any results. enter image description here

I tried a where clause for another entity and it worked fine. enter image description here

Can you please let me know what I am doing wrong?

Regards, Sathya

score 1 · Answer 1 · answered Feb 27 '13 at 04:59

1

It looks like you are trying to querying an entity with unindexed property. An entity with an unindexed property behaves as if the property were not set: queries with a filter or sort order on the unindexed property will never match that entity.

More info : https://developers.google.com/appengine/docs/python/datastore/indexes#Unindexed_Properties

answered Feb 27 '13 at 04:59

Nijin Narayanan

2,269
2
27
46

Thanks Nijin. I will create an index and check it out again. – Sathya Feb 27 '13 at 05:06
@Sathya did it work? It looks like each entity is indexed and you can define index only for multiple entities. – Aniket Thakur Oct 18 '15 at 14:55

GQL not working when I select a particular field

1 Answers1