Thanks for the link Simon On Jul 14, 7:34 pm, Simon <[email protected]> wrote: > The "Query Filters" section under the following link it explains the > problem you're > hitting:http://code.google.com/appengine/docs/java/datastore/queriesandindexe... > > 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.
