Yuchh Ignore this. That will teach me for posting whilst half asleep.
Complete rubbish T On Mar 13, 11:50 pm, Tim Hoffman <[email protected]> wrote: > Hi > > You could try this. > > Create a composite string field of all three values padded with 0's > for the numerics so that they will sort alphabetically > > for instance a new field (composite_field) date + foo + bar > > where date 20100221 (YYYYMMDD) > foo is 000000002 > bar is 000000041 > > So your field value will be > > 20100221000000002000000041 > > Now you can use multiple inequality filters on the same field > > For instance > assuming the date we want is > 01 jan 2010 > and we want foo > 0 > and bar < 42 > > Query q = new Query("MyKind") > .addFilter("composite_field", GREATER_THAN, > '20100101000000000') Which sorts the date > 01 Jan 2010 and foo > > 1 > .addFilter("composite_field", LESS_THAN, > '20100101000000000000000042'); which gets you the less than 42 > > It might work for you. > > Cheers > > T > > On Mar 13, 7:53 pm, Patrick Twohig <[email protected]> wrote: > > > > > So, the business requirements of my application need a query which needs to > > search for a property (let's call it "foo") and a date property such that it > > will filter out all objects older than a certain date. I guess in GAE/J > > this would be something like.... > > > Query q = new Query("MyKind") > > .addFilter("foo", GREATER_THAN, 0) > > .addFilter("bar", LESS_THAN, 42) > > .addFilter("date", GREATER_THAN, someDate); > > > But, I'm guessing that wouldn't work because it's got inequality filters on > > multiple properties. Would there be a way to get a similar result without > > loading a huge amount of entities into memory and filtering them out > > manually? > > > -- > > Patrick H. Twohig. > > > Namazu Studios > > P.O. Box 34161 > > San Diego, CA 92163-4161 -- 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.
