Yuchh
Ignore this. That will teach me for posting whilst half asleep.
Complete rubbish
T
On Mar 13, 11:50 pm, Tim Hoffman <zutes...@gmail.com> 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 <patr...@namazustudios.com> 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 google-appeng...@googlegroups.com.
To unsubscribe from this group, send email to
google-appengine+unsubscr...@googlegroups.com.
For more options, visit this group at
http://groups.google.com/group/google-appengine?hl=en.
