cancel
Showing results for 
Search instead for 
Did you mean: 

org.activiti.engine.task.TaskQuery.taskNameLike(%searchString%) is case sensitive

onlinesun
Champ in-the-making
Champ in-the-making
I'm trying to add a text filter to search tasks, but when I use org.activiti.engine.task.TaskQuery.taskNameLike(%searchString%), "searchString" is case sensitive, is there a method like taskNameLikeIgnoreCases?
1 REPLY 1

bmarkmann
Champ in-the-making
Champ in-the-making
What database are you using?  In Oracle, for instance, the ability to do case-insensitive comparisons is handled by server-side configuration… not sure whether this would break anything else in the engine / API, but take a look at this:

http://www.dba-oracle.com/t_case_insensitive_indexes_searches.htm

A more general solution might to be leverage the management service to build a query directly against the task table(s) and use your DB's equivalent of a "to upper" function to do the query.  The ability to do native queries against the Activiti engine schema is covered here:

http://activiti.org/userguide/index.html#queryAPI

- Bill