I believe you can do this in two ways:
Either using GQL (see:
http://code.google.com/appengine/docs/python/datastore/gqlreference.html)
eg: SELECT * FROM House WHERE cost > 5000 AND cost < 150000 AND rooms
>= 3... etc
Or by chaining your filters on your Model class (http://
code.google.com/appengine/docs/python/datastore/
queryclass.html#Query_filter):
eg: House.filter('cost >', 5000).filter('cost <',
150000).filter('rooms >= ', 3)... etc
Note you can't use OR in GQL.
P.S. Putting URGENT in your message title generally guarantees a slow
response on message boards... :-)
On Sep 19, 9:11 am, "GAE-framework.googlecode.com"
<[email protected]> wrote:
> Hillo GAE developers!
>
> I have a serious situation with datastore. I need select data from
> model with multiple criteria. I have a House model, where exists
> fields: cost, rooms, floor. I need filter all houses, where cost >
> 50000 and < 150000, and also rooms > = 3 and < 5, and also floor >= 1
> and < 3.
>
> How can I select this dataset? As I see, the Datastore says that I can
> use filter criteria with >, <, >=, <= and != only on one column. But I
> reallly need use this rules on multiple columns.
>
> Please, help me!!!
> How to implement my task with Datastore limitations?
>
> Thank you. I really need your help.
--
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.
