The "Query Filters" section under the following link it explains the problem you're hitting: http://code.google.com/appengine/docs/java/datastore/queriesandindexes.html#Introducing_Queries
On Jul 14, 1:10 pm, Vikas Hazrati <[email protected]> wrote: > Further to my previous > questionhttp://groups.google.com/group/google-appengine/browse_thread/thread/... > in which we were getting the following error .... > 'or' filters can only check equality > Now for the sake of datanucleus and datastore we changed the > functionality to be equality for the time being > so the query reads like > @NamedQuery(name="User.findActiveByUsernamePattern", > query="SELECT DISTINCT user " + > "FROM User as user " + > "WHERE (firstName = :pattern OR > lastName = :pattern) " + > "AND (active = true) " + > "ORDER BY firstName, lastName") > and now I get > org.datanucleus.store.appengine.query.DatastoreQuery > $UnsupportedDatastoreFeatureException: Problem with query <SELECT > FROM > User as user WHERE (user.firstName = :pattern OR user.lastName > = :pattern) AND (user.active = true) ORDER BY user.firstName, > user.lastName>: Or filters cannot be applied to multiple properties > (found both firstName and lastName). > A search on the net does not show too many results for the problem > that we are facing. > Are we the only ones facing this issue? No one else is trying to port > a legacy application to GAE????? Isn't this quite a normal routine > query in JPA??? > @datanucleus, @gae please respond. > Regards | Vikaswww.inphina.comwww.thoughts.inphina.com -- You received this message because you are subscribed to the Google Groups "Google App Engine for Java" 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-java?hl=en.
