How to search structured properties ? google app engine

Question

I have two models categories and cities:

class category(ndb.Model):
      hidden = ndb.BooleanProperty()
      categoryName = ndb.StringProperty()

class city(ndb.Model):
      categories = ndb.StructuredProperty(category,repeated = True)
      cityName = ndb.StringProperty()

I have cityEntity: How to return categories list that contain just category.hidden = false ?

edit: it's possible to get the categories list, then Loop through the categories list and extract just the categories which not hidden

for example I have city entity:

categories_unhidden_list = []
for category in city.categories :
    if not category.hidden :
        categories_unhidden_list.append(category)

but I would like to get the categories_unhidden_list from the datastore !

Answer 1

A query will match only what is queried for. If the entity fulfills the condition, it will return the entity. If you have a repeated property and a query matches one of the values, it will return the whole list in the entity, not only the one that matches. This is why repeated properties should almost always be either a key, a simple value, or a simple key value pair.

You may want to look into A) projection queries and B) structuring your data so that you can query for categories that have a value of x and a parent-entity of key_y, instead of querying for Y's where they have key_x in their repeated list.