KnowledgeHub
Questions
Tags
Users
Search
Alex Rivera
|
Logout
Edit Question
Title
Body
I have some ticket numbers that may have numbers and letters mixed. I'll be passing in the ticketNumberIds into this method (user input) and I want it to query against the Oracle database and have the query pick up tickets that differ by upper and lower cases. How do I make the following a case-insensitive query? public List<TicketDO> getTicketDOsById(final List<String> ticketNumberIds) { String myQuery = "from TicketDO t where t.ticketNumberId in (:ticketNumberIds)"; return getEntityManager().createQuery(myQuery).setParameter("ticketNumberIds", ticketNumberIds) .getResultList(); }
Tags (comma-separated)
Save Edits
Cancel