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()