Hi,
I have this query:
queryString= " select m from ChrMemoria m " +
"where concat (lower(m.codigo)) like concat('%',concat(lower(:codigo),'%')) " +
"and concat (lower(m.nombre)) like concat('%',concat(lower(:nombre),'%')) " +
"and concat (lower(m.departamento)) like concat('%',concat(lower(:departamento),'%')) ";
I have in jsf a h:selectmanymenu join to a variable in entity delegacionList. I want check if m.delegacion is like someone of delegacionList. I dont know the code, i knew this:
queryString += "and concat(lower(m.delegacion))= some elements(:delegacionList) ";
Can someone help me or tell me the rigth way?
Thanks a lot of!
Pedro.