"IN" statement in play using hql

How can I write an HQL query like same SQL query like this:

select * from User开发者_StackOverflow社区s u where u.id in (1, 3, 4)

Try User.find("id in (:ids)").bind("ids", new Long[]{1L,3L,4L}).fetch()

I suggest you use native query to utilize your SQL query, so that you don't have to convert to HQL.

The simplest way to do this with play is

public static void findByIds(List<Long> userIds) {
    find("from Users u where u.id in (?1)", userIds).fetch();
}