Hi,
We have the following named query in JPA which we want to execute on
the datastore
@NamedQuery(name="User.findActiveByUsernamePattern",
query="SELECT DISTINCT user " +
"FROM User as user " +
"WHERE firstName like :pattern OR
lastName like :pattern " +
"AND active = true " +
"ORDER BY firstName")
when we execute the test, we get the following error
org.datanucleus.store.appengine.query.DatastoreQuery
$UnsupportedDatastoreFeatureException: Problem with query <SELECT
FROM
User as user WHERE firstName like :pattern OR lastName like :pattern
AND active = true ORDER BY firstName>: 'or' filters can only check
equality
What is the best way to resolve this? we can write 2 queries one for
firstName and other for lastname but that is ugly.
Regards | Vikas
www.inphina.com
www.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 google-appengine-j...@googlegroups.com.
To unsubscribe from this group, send email to
google-appengine-java+unsubscr...@googlegroups.com.
For more options, visit this group at
http://groups.google.com/group/google-appengine-java?hl=en.
