[google-appengine] Datastorequery with OR condition on multiple properties

2011-01-08 Thread frank
Hello,

I have a JPA query like that:

select from Kind k where attr1 = "a" and ( attr2 = true or attr3 =
false)

I get the  exception: "Or filters cannot be applied to multiple
properties"

Is there a recommended way get the entites with conditions like that
or do I have to perform two queries one after another and combine the
results in the application.

-- 
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.



Re: [google-appengine] Datastorequery with OR condition on multiple properties

2011-01-08 Thread Robert Kluin
Hi Frank,
  Either use two queries, if the result sets are small enough, or add
another property to your model, attr2_or_not_attr3, and query using
that.  Adding the new attribute will give you better performance if
you have many results, and may me the only way if your sets are very
large.


Robert





On Sat, Jan 8, 2011 at 09:01, frank  wrote:
> Hello,
>
> I have a JPA query like that:
>
> select from Kind k where attr1 = "a" and ( attr2 = true or attr3 =
> false)
>
> I get the  exception: "Or filters cannot be applied to multiple
> properties"
>
> Is there a recommended way get the entites with conditions like that
> or do I have to perform two queries one after another and combine the
> results in the application.
>
> --
> 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.
>
>

-- 
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.