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.