topic org.activiti.engine.task.TaskQuery.taskNameLike(%searchString%) is case sensitive in Alfresco Archive https://connect.hyland.com/t5/alfresco-archive/org-activiti-engine-task-taskquery-tasknamelike-searchstring-is/m-p/171871#M125105 <HTML><HEAD></HEAD><BODY><SPAN>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?</SPAN></BODY></HTML> Wed, 04 Dec 2013 20:24:36 GMT onlinesun 2013-12-04T20:24:36Z org.activiti.engine.task.TaskQuery.taskNameLike(%searchString%) is case sensitive https://connect.hyland.com/t5/alfresco-archive/org-activiti-engine-task-taskquery-tasknamelike-searchstring-is/m-p/171871#M125105 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? Wed, 04 Dec 2013 20:24:36 GMT https://connect.hyland.com/t5/alfresco-archive/org-activiti-engine-task-taskquery-tasknamelike-searchstring-is/m-p/171871#M125105 onlinesun 2013-12-04T20:24:36Z Re: org.activiti.engine.task.TaskQuery.taskNameLike(%searchString%) is case sensitive https://connect.hyland.com/t5/alfresco-archive/org-activiti-engine-task-taskquery-tasknamelike-searchstring-is/m-p/171872#M125106 <HTML><HEAD></HEAD><BODY><SPAN>What database are you using?&nbsp; 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:</SPAN><BR /><BR /><A href="http://www.dba-oracle.com/t_case_insensitive_indexes_searches.htm" rel="nofollow noopener noreferrer">http://www.dba-oracle.com/t_case_insensitive_indexes_searches.htm</A><BR /><BR /><SPAN>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.&nbsp; The ability to do native queries against the Activiti engine schema is covered here:</SPAN><BR /><BR /><A href="http://activiti.org/userguide/index.html#queryAPI" rel="nofollow noopener noreferrer">http://activiti.org/userguide/index.html#queryAPI</A><BR /><BR /><SPAN>- Bill</SPAN></BODY></HTML> Wed, 04 Dec 2013 21:40:06 GMT https://connect.hyland.com/t5/alfresco-archive/org-activiti-engine-task-taskquery-tasknamelike-searchstring-is/m-p/171872#M125106 bmarkmann 2013-12-04T21:40:06Z