Hibernate Entity Manager

33 views Asked by At

I have a list of Date objects. I assigned that list in setParameter ("dates", datesList) and then I did c.createDate IN (:dates). It does not work (query returns 0 results back). How do I do this?

em.createQuery("""
   select u.name, s.description, c.completed, c.input,              c.adjustments, c.taktTime
     from CountEntity c, SkillEntity s, FwmsUserEntity u,   SkillTypeEntity t
       where c.skill = s.id
          AND s.description IN (:skillsList)
          AND c.createDate IN (:dates)
          and t.id=3 and t.id=s.skillType
          and c.fwmsUser = u.id
          """).setParameter("skillsList", skillsList).setParameter("dates", dates).getResultList()
0

There are 0 answers