Hi,
I'd like to make a query with WHERE MEMBER OF.
This is my query
SELECT DISTINCT pav FROM EPCI AS epci, IN (epci.listTown) AS town, IN (town.listPAV) pav WHERE epci.id = ?1 AND pav.flag = :flag AND pav.oneLocalisation.status MEMBER OF :status ORDER BY pav.name
Status is an ENUM and :status a list of enum
List<Status> listTmp = new ArrayList<Status>();
listTmp.add(Status.create);
listTmp.add(Status.update);
query.setParameter("status", listTmp);
When i run I have an exception
Internal Exception: line 1:171: expecting IDENT, found ':status'
Thanx for your help
Shucky