Google App Engine Datastore multi-valued properties matches only when having > 1 values

Asked Jul 05 '13 at 09:14

Active Jul 05 '13 at 09:14

Viewed 176 times

I have a data table as follows.

data table

When I execute the GQL from the Admin Console:

SELECT * FROM DbFeed WHERE broadcasterAccountNames='gmnexuss@gmail.com'

The result I got is only 1 row, which is the one with id=10001. What's wrong with it? Why didn't it return me the one with id=1002 too?

asked Jul 05 '13 at 09:14

Are the 2 records in different namespaces? – Rob Curtis Jul 05 '13 at 09:35
maybe the first record was not indexed (index added later ?) – koma Jul 05 '13 at 11:06
@koma, if i'm not wrong, index of single property is always added automatically? I don't have any manually/automatically generated index in my app. Is it even possible to have an index that only apply to some (not all) rows? – Randy Sugianto 'Yuku' Jul 05 '13 at 17:03
@Bert How do I check the namespace? There should not be any other namespaces, since I have never added any namespaces. – Randy Sugianto 'Yuku' Jul 05 '13 at 17:04
If you have namespace there is an option (under options) to choose namespace where querying in console. However, if you never added namespace, then I don't suspect it is a namespacing issue. – Rob Curtis Jul 05 '13 at 20:12
what happens if you run a query in code, does it still only return 1 record? – Rob Curtis Jul 05 '13 at 20:12
@yuku No, the index is built at write time AFAIK. The index is added without config but previously written records not indexed. Re-write the record and try again. – koma Jul 06 '13 at 08:24
@Bert using namespace, this looks different in the console cfr screenshot – koma Jul 06 '13 at 16:13
@yuku is this resolved? – tony m Jul 09 '13 at 05:46

0 Answers0