Hi, To reach your target, you can always select on 1 criterion from the datastore (the one with least results to be most efficient) and then do the second filtering in your program.
regards didier On Nov 16, 6:40 pm, Vik <vik....@gmail.com> wrote: > hie > > This seems to implies i cannot use the above suggested method as timeFrom > and timeTo are two different attributes in my entity and i have to check if > a value is in between of timeFrom and timeTo > > Then how should i get this? > > Thankx and Regards > > Vik > Founderwww.sakshum.comwww.sakshum.blogspot.com > > On Tue, Nov 16, 2010 at 9:37 PM, Didier Durand <durand.did...@gmail.com>wrote: > > > Hi, > > > Also see all details at > > >http://code.google.com/appengine/docs/java/datastore/queriesandindexe... > > > You can filter on a range on a given property: it's described there. > > > regards > > didier > > > On Nov 16, 4:33 pm, Robert Lancer <robert.lan...@gmail.com> wrote: > > > You can set two filter properties, one for greater than and one for > > > less than. > > > >http://code.google.com/appengine/docs/java/javadoc/com/google/appengi... > > > > Ex: > > > > Query q = new Query(KIND); > > > q.addFilter("Prop" , Query.FilterOperator.GREATER_THAN_OR_EQUAL , > > > startVal); > > > q.addFilter("Prop" , Query.FilterOperator.LESS_THAN , endVal); > > > > On Nov 16, 9:57 am, Vik <vik....@gmail.com> wrote: > > > > > Hie > > > > > I want to find rows where a number exist in between of two column > > values > > > > which are say numFrom and numTo. > > > > So does app engine query support between operator to write like > > > > > select myclass where myNum in between numFrom and numTo ? > > > > > Thankx and Regards > > > > > Vik > > > > Founderwww.sakshum.comwww.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 > > google-appengine-j...@googlegroups.com. > > To unsubscribe from this group, send email to > > google-appengine-java+unsubscr...@googlegroups.com<google-appengine-java%2bunsubscr...@googlegroups.com> > > . > > 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 google-appengine-j...@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.
