Hie I got this reply 1.5 years ago. So is IN query still not supported?
Thankx and Regards Vik Founder www.sakshum.com www.sakshum.blogspot.com On Wed, May 20, 2009 at 10:26 PM, Max Ross <[email protected]<maxr%[email protected]> > wrote: > Sorry Vik, I now realize you were asking about an "IN" query. "IN" queries > are essentially the same as "OR" queries - just nicer syntax because all the > filters apply to the same field. As with "OR", "IN" is not supported but > you can get the results by issuing multiple queries. > > Max > > > On Tue, May 19, 2009 at 9:02 PM, Vik <[email protected]> wrote: > >> Hie Max >> >> I saw this and thankx for it. >> >> But what i saw there is only single value is there inside contains. Say I >> have an entity Color with single attribute colorName. >> >> And it has already 3 entities with values "Red", "Green", "Blue". >> >> Now, I want to query this Entity to check if colorName contains any of the >> value in "Green", "Blue", "Voilet", "orange" >> >> So is it possible to use contains in this case by passing the >> list "Green", "Blue", "Voilet", "orange" and getting entities which matches >> to any of these values? >> >> >> Thankx and Regards >> >> Vik >> Founder >> www.sakshum.com >> www.sakshum.blogspot.com >> >> >> On Wed, May 20, 2009 at 9:15 AM, Max Ross >> <[email protected]<maxr%[email protected]> >> > wrote: >> >>> Hi Vik, >>> >>> You're certainly welcome to read the JDO spec, but the short answer is >>> that contains() has the same syntax in JDOQL that it does in Java. Here's >>> an example from the App Engine test suite: >>> >>> http://www.google.com/codesearch/p?hl=en#79kbA0UmWLw/trunk/tests/org/datanucleus/store/appengine/query/JDOQLQueryTest.java&q=contains%20jdoqlquerytest%20package:http://datanucleus-appengine >>> \.googlecode\.com&l=898 >>> >>> Hope this helps, >>> Max >>> >>> >>> On Tue, May 19, 2009 at 8:28 PM, Vik <[email protected]> wrote: >>> >>>> Hie Max >>>> >>>> Before that can you point me if the usage of contains is documented >>>> somewhere? So, that I have correct expectations as well. >>>> >>>> Thankx and Regards >>>> >>>> Vik >>>> Founder >>>> www.sakshum.com >>>> www.sakshum.blogspot.com >>>> >>>> >>>> On Wed, May 20, 2009 at 4:12 AM, Max Ross >>>> <[email protected]<maxr%[email protected]> >>>> > wrote: >>>> >>>>> As of the latest SDK we support the contains() operator in JDOQL. I'd >>>>> recommending trying a query in the dev appserver and if it doesn't yield >>>>> the >>>>> result you expect please post what you expected along with your code and >>>>> we'll have a look. >>>>> >>>>> Thanks, >>>>> Max >>>>> >>>>> >>>>> On Tue, May 19, 2009 at 3:45 AM, Vik <[email protected]> wrote: >>>>> >>>>>> ny updates plz >>>>>> >>>>>> Thankx and Regards >>>>>> >>>>>> Vik >>>>>> Founder >>>>>> www.sakshum.com >>>>>> www.sakshum.blogspot.com >>>>>> >>>>>> >>>>>> On Mon, May 18, 2009 at 6:00 PM, Vik <[email protected]> wrote: >>>>>> >>>>>>> Hie >>>>>>> >>>>>>> not sure where I read but just want to confirm: >>>>>>> >>>>>>> I have a list of values (in the form of a HashSet). I want to filter >>>>>>> all the entitites which contains any of the value from set for a >>>>>>> particular attribute. >>>>>>> >>>>>>> Is it supported by JDOQL? or I need to first query all entities and >>>>>>> then manually filter out? >>>>>>> >>>>>>> Thankx and Regards >>>>>>> >>>>>>> Vik >>>>>>> Founder >>>>>>> www.sakshum.com >>>>>>> www.sakshum.blogspot.com >>>>>>> >>>>>> >>>>>> >>>>>> >>>>>> >>>>> >>>>> >>>>> >>>> >>>> >>>> >>> >>> >>> >> >> >> > > --~--~---------~--~----~------------~-------~--~----~ > You received this message because you are subscribed to the Google Groups > "Google App Engine for Java" group. > To post to this group, send email to > [email protected] > To unsubscribe from this group, send email to > [email protected]<google-appengine-java%[email protected]> > For more options, visit this group at > http://groups.google.com/group/google-appengine-java?hl=en > -~----------~----~----~----~------~----~------~--~--- > > -- You received this message because you are subscribed to the Google Groups "Google App Engine for Java" 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-java?hl=en.
