KnowledgeHub
Questions
Tags
Users
Search
Alex Rivera
|
Logout
Edit Question
Title
Body
I am using JPQL query to check whether the list contains the specified enum values. If the enum value is a single element to check then it is pretty simple. In query expression, query = "... where s.status = :status"; and then set parameter like query.setParameter("status", statusValue); But I want to check something like below query = "... where s.status IN (:statusList)"; where statusList is a string of numbers (e.g. "0,1,2" which means the list of the values of status) But I can't find a solution. I have also checked with s.status.ordinal() IN (statusList) in query but no luck. I'm using JPA Implementation: EclipseLink (JPA 2.0) My Entity's actual name is SType public enum SType { REQUISITION, PURCHASE, FINISHED, // others RETURN; } QUERY: String querySt = "select s.slipType.slipNameSt,s.slipNumberSt, s.idNr from Slip s where s.slipType.sType IN (:enumTypeListt)"; em.createQuery(querySt).setParameter("enumTypeList", EnumSet.of(SType.REQUISITION, SType.PURCHASE));
Tags (comma-separated)
Save Edits
Cancel