Twig Persist has support for OR queries on multiple properties.
http://code.google.com/p/twig-persist/
You example is coded like this:
TypedFindCommand command =
datastore.find().type(Person.class).addFilter)"active", EQUAL, true);
command.addChildQuery().addFilter("firstName", EQUAL, aFirstName);
command.addChildQuery().addFilter("lastName", EQUAL, aLastName);
Iterator<Person> people = command.returnResultsNow();
On 14 Jul 2010, at 19:10, Vikas Hazrati wrote:
Further to my previous question
http://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 | 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 [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
.
--
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.
