Win a copy of Penetration Testing Basics this week in the Security forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

JPQL - Query Parameter

Israel Fonseca
Posts: 7
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Supose the following situation:

class ObjectA

Integer id;
List<ObjectB> list;

How can i make a JPQL that retrives a list of ObjectA that have at least N ObjectB. N is variable number. Example:

table ObjectA
table ObjectB
[id] [fk_objectA]
1 1
2 1
3 2

My search method would be...

List<ObjectA> search(List<ObjectB> param){
return em.createQuery("from ObjectA o where o have at least these :param").setParameter("param",param).getResultlist()

If param is a list with ObjectB(id=1) it would retrieve: ObjectA(id=1), the same would be true if param was a list with [ObjectB(id=1),ObjectB(id=2)]

Off course that this query don't work, but i want to do something like that. Is it possible? Or do i have to make a lot of string concatenation?


  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic