Answers to: TaskQuery case insensitive searchhttps://answers.axonivy.com/questions/1442/taskquery-case-insensitive-search<p>Hi all,</p> <p>Is it possible to search against String Task properties with a TaskQuery so that the search is performed case insensitive.</p> <pre><code> TaskQuery stringFieldQuery = TaskQuery.create(); stringFieldQuery.where().name().isLike("my task name"); </code> </pre> <p>I would like that such a query returns the tasks which name is "MY Task NAme". Thanks in advance</p> <p>Emmanuel</p>enWed, 15 Mar 2017 08:42:01 -0400Answer by Reto Weisshttps://answers.axonivy.com/questions/1442/taskquery-case-insensitive-search/2493<p>Hi Mr. DK</p> <p>We have done some improvements for some databases (mySql, SQLServer). If you use these database then the queries working case insensitiv. For the other database (Oracle, PostgreSql) we are still investigating how we can solve the problem. </p> <p>If you have access to our confluence then the following page may also help you: <a href="https://jira.axonivy.com/confluence/display/XIVY/Case+insensitive+LIKE+operations">https://jira.axonivy.com/confluence/display/XIVY/Case+insensitive+LIKE+operations</a></p>Reto WeissWed, 15 Mar 2017 08:42:01 -0400https://answers.axonivy.com/questions/1442/taskquery-case-insensitive-search/2493Answer by khanh11166https://answers.axonivy.com/questions/1442/taskquery-case-insensitive-search/2492<p>Hi Reto, </p> <p>This question is answered 2 years ago. How about now, is there any improve and update on this problem?</p> <p>Thanks, Mr. DK</p>khanh11166Wed, 15 Mar 2017 05:01:50 -0400https://answers.axonivy.com/questions/1442/taskquery-case-insensitive-search/2492Answer by Reto Weisshttps://answers.axonivy.com/questions/1442/taskquery-case-insensitive-search/1444<p>Hi Emmanuel</p> <p>Sorry but it is currently not possible to perform case insensitiv task queries. If you only want to search for a task name use the old <code>ivy.wf.findTask(...)</code> API. It supports <code>RelationalOperator.EQUAL_IGNORE_CASE</code> and <code>RelationalOperator.NOT_EQUAL_IGNORE_CASE</code> operations.</p>Reto WeissThu, 20 Aug 2015 17:03:10 -0400https://answers.axonivy.com/questions/1442/taskquery-case-insensitive-search/1444