Play Framework - find Object with "Or" in the query

It is possible to use "AND" while querying for Objects in Entity like

Post.find("byTitleLikeAndAuthor", "%hello%", connectedUser).fetch();

but is it possible to user "OR" while querying, like

Post.find("byNameOrEmail", name, email).fetch(); 

Thank 开发者_Python百科you

Fixed!!

Use Post.find(" name = ? or email ?", name, email).fetch();

While using "where" in the query, it fails saying "unexpected token"

It is indeed possible to use "And" clauses when constructing objects, but I'm not aware of a possibility in simplified query to use "Or".

However, play can be used in many ways. Instead of writing :

Post.find("byNameOrEmail", name, email).fetch(); 

You can write :

Post.find("name = ? or email = ?", name, email).fetch();

using JPQL syntax.

It's not possible to use simplified query with or. To enable it you must change the implementation of findByToJPQL in the class play.db.jpa.JPQL. Wrote test and enhance the documentation and create a patch. How ever you can use the JPQL.