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.