multi-valued property query in GAE

Posted by Tim on Stack Overflow See other posts from Stack Overflow or by Tim
Published on 2010-12-10T03:47:00Z Indexed on 2010/12/29 10:54 UTC
Read the original article Hit count: 172

Filed under:

gae-datastore

|

jdo

|

multivalue

class Person{ @Persistent private List tags = ArrayList() }

I want to let the user query a person based on his/her tag, so I had my query filter like this:

tags.contains(tagValue1)

and if the user want to search for multiple tags, I would just add to the filter so if the user is searching for 3 tags, then the query would be

tags.contains(tagValue1) && tags.contains(tagValue2) && tags.contains(tagValue3)

I think this approach is wrong, because the datastore then needs to have an index that have the tags property three times... and if the user search for more than 3 tags at a time then it will be broken.

What's the proper way to do this? Do you guys have any suggestions?

© Stack Overflow or respective owner

Related posts about gae-datastore

How to create local copy of GAE datastore?

as seen on Stack Overflow - Search for 'Stack Overflow'
I want to make client version of GAE app that store exact data of online version.(myapp.appspot.com) If i can use sdk instead, is any library or tools to sync online and sdk version? I try using bulkloader but i can't load downloaded data to local SDK? Please help. >>> More
GAE Datastore Put()

as seen on Stack Overflow - Search for 'Stack Overflow'
def post(self): update = self.request.get('update') if users.get_current_user(): if update: personal = db.GqlQuery("SELECT * FROM Personal WHERE __key__ = :1", db.Key(update)) personal.name = self.request.get('name') personal.gender = self.request… >>> More
Using key().id() on GAE Datastore and reverse geocoding

as seen on Stack Overflow - Search for 'Stack Overflow'
I have 6000 data of district, subdistrict. I need to represent this on dependent dropdown. The datamodel is for example; class Location(db.Model): location_name = db.StringProperty() location_parent = db.IntegerProperty() location_parent is reference to key() or id()? Still cannot decide… >>> More
GAE datastore eager loading in python api

as seen on Stack Overflow - Search for 'Stack Overflow'
I have two models in relation one-to-many: class Question(db.Model): questionText = db.StringProperty(multiline=False) class Answer(db.Model): answerText = db.StringProperty(multiline=False) question = db.ReferenceProperty(Question, collection_name='answers') … >>> More
GAE datastore encoding

as seen on Stack Overflow - Search for 'Stack Overflow'
All data which added today into datastore was unintelligible symbols. >>> More

Related posts about jdo

Why "import javax.jdo.* "caused error ?

as seen on Stack Overflow - Search for 'Stack Overflow'
I have a class uses the following lines, it works fine in a Google App Engine project: import javax.jdo.annotations.IdGeneratorStrategy; import javax.jdo.annotations.IdentityType; import javax.jdo.annotations.PersistenceCapable; import javax.jdo.annotations.Persistent; import javax.jdo.annotations… >>> More
Problems Mapping a List of Serializable Objets with JDO

as seen on Stack Overflow - Search for 'Stack Overflow'
I have two classes Invoice and InvoiceItem. I would like Invoice to have a List of InvoiceItem Objets. I have red that the list must be of primitive or serializable objects. I have made InvoiceItem Serializable. Invoice.java looks like import java.util.ArrayList; import java.util.Date; import java… >>> More
How to do this GQL query in JDO

as seen on Stack Overflow - Search for 'Stack Overflow'
I have about 50k entities stored in appengine. I am able to look up an individual record via the GQL admin interface with a query like: SELECT * FROM Pet where __key__ = KEY( 'Pet','Fido') But I'm having trouble figuring out how to do a batch version of this via JDO. Right now I have this: … >>> More
GAE/JDO: How to check whether a field in a detached object was loaded

as seen on Stack Overflow - Search for 'Stack Overflow'
My DAO detaches and then caches certain objects, and it may retrieve them with different fetch groups. Depending on which fetch group was used to retrieve the object, certain fields of that object may be available, or not. I would like to be able to test whether a given field on that object was… >>> More
GAE, JDO, count() doesn't work ?

as seen on Stack Overflow - Search for 'Stack Overflow'
On GAE with Spring/JDO after saving 2 entities (in transaction). On calling getById - entities fetched from data storage. On calling getCount() returns "0" and - on calling getAll() - returns empty collection. plz help me ! DAO: @Override public Long getCount() { return ((Integer) getJdoTemplate()… >>> More