CODEWITHSUNDEEP
javajpaexpressioncriteria-api
user1414341
user1414341

Reputation: 321

JPA Criteria API IN expression Parameter list

Is there a possibility to use a parameter list in Criteria API .in expression?

I have something like this: 

    List<Long> list = new ArrayList<Long>();
    list.add((long)1);
    list.add((long)2);
    list.add((long)3);


CriteriaBuilder cb = em.getCriteriaBuilder();
CriteriaQuery<Bewerbung> criteriaQuery = cb.createQuery(Bewerbung.class);
Root<Bewerbung> bewerbung = criteriaQuery.from(Bewerbung.class);

criteriaQuery.select(bewerbung).where(
cb.in(bewerbung.get(Bewerbung_.bewerberNummer)).value(list);

return em.createQuery(criteriaQuery).getResultList();

The expression .value(list) does not work as value() is expecting a paramter of type long not a list. In my case it is not possible to use a subquery. Can anyone help me on this issue?

Upvotes: 26

Views: 56358

Answers (2)

jFrenetic
jFrenetic

Reputation: 5552

No need to use CriteriaBuilder#isTrue. This should suffice: 

criteriaQuery.select(bewerbung)
             .where(bewerbung.get(Bewerbung_.bewerberNummer)
             .in(list));

Upvotes: 37

JB Nizet
JB Nizet

Reputation: 692151

cb.isTrue(bewerbung.get(Bewerbung_.bewerberNummer).in(list));

should do the trick, AFAIK.

Upvotes: 34

Related Questions