My scenario of create an additional generic table Animals that tabulates all of the selling action into a list and search the Animals entries for that user is what I came across to use IN
And unfortuantely, my OR would be used on two different fields. I am starting to think the only solution is to present the results by querying twice and combining the results in the backend. On Sep 6, 6:40 am, Niklasro <[email protected]> wrote: > On Sep 6, 3:53 am, killer barney <[email protected]> wrote: > > > I'm a dunce. how does query filters help in the OR process? > > > So do I do a query with contains "dog" and "cat"? > > > On Sep 5, 8:44 pm, Nate Bauernfeind <[email protected]> > > wrote: > > > >http://code.google.com/appengine/docs/java/datastore/queriesandindexe... > > > > See "Query Filters". Should answer your how-to question. > > > > In the backend it actually does two separate queries, but in parallel > > > (then > > > does any merging/union-ing based on your entire query after retrieving the > > > results). There are some google tech talks on how the datastore works > > > which > > > should give you a really good idea why it is done this way. > > > > On Sun, Sep 5, 2010 at 10:34 PM, killer barney <[email protected]> wrote: > > > > This is something I never figured out how to do. How do you > > > > supplement an OR statement in datastore? > > > > > So let's say I have a user who sells Dogs and Cats. How do I get a > > > > list of all of the dogs and cats that a user sells? I thought of 2 > > > > ways, query both tables and combine the results in the backend or > > > > create an additional generic table Animals that tabulates all of the > > > > selling action into a list and search the Animals entries for that > > > > user. > > > > > I created this scenario just so you can have an idea of what I am > > > > looking for, but in reality, my "cats" table may consist of hundreds > > > > of users. I'm not sure if creating a combined list property of Dog > > > > and Cat users is the way to go. And doing two queries just doesn't > > > > seem right either. Is there a better way to do this? > > A replacement in many cases is the IN operator. Did you try it? > Regards > Niklas -- You received this message because you are subscribed to the Google Groups "Google App Engine" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/google-appengine?hl=en.
