You can use "contains" in JDO instead of SQL's IN(), but the
implementation is a separate query for each item in the list.
(http://code.google.com/appengine/docs/java/datastore/jdo/
queries.html).
There's also a limit of 30 to the number of items in the array.
This from appengine tests is expected to work:
Query q = pm.newQuery("select from " + Flight.class.getName() + "
where :ids.contains(id)");
List<Flight> flights = (List<Flight>) q.execute( Arrays.asList(key,
e1.getKey(), e2.getKey()) );
On May 8, 5:14 pm, mscwd01 <mscw...@gmail.com> wrote:
> Hey
>
> I have an entity with an Int Array and I would like to perform a query
> on the contents of the Array. For example, I would like to return
> entities which have a certain number within the array, I.e.
>
> Select * From MyObject Where numberArray contains 2
>
> Is this possible in any way, shape or form?
>
> Thanks
--
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 google-appengine-java@googlegroups.com.
To unsubscribe from this group, send email to
google-appengine-java+unsubscr...@googlegroups.com.
For more options, visit this group at
http://groups.google.com/group/google-appengine-java?hl=en.
