[google-appengine] Re: Need help with a query...

2010-03-14 Thread Stephen
On Mar 13, 11:53 am, Patrick Twohig 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 somet

Re: [google-appengine] Re: Need help with a query...

2010-03-14 Thread Patrick Twohig
What about two queries, one for the range, one for the date then take the union of the two sets? On Sat, Mar 13, 2010 at 8:49 AM, Tim Hoffman wrote: > Yuchh > > Ignore this. That will teach me for posting whilst half asleep. > > Complete rubbish > > T > > On Mar 13, 11:50 pm, Tim Hoffman wrote

[google-appengine] Re: Need help with a query...

2010-03-13 Thread Tim Hoffman
Yuchh Ignore this. That will teach me for posting whilst half asleep. Complete rubbish T On Mar 13, 11:50 pm, Tim Hoffman 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 > > fo

[google-appengine] Re: Need help with a query...

2010-03-13 Thread Tim Hoffman
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 (MMDD) foo is 2 bar is 00041 So your field valu