TaskQuery case insensitive search

Question

Hi all,

Is it possible to search against String Task properties with a TaskQuery so that the search is performed case insensitive.


    TaskQuery stringFieldQuery = TaskQuery.create();
    stringFieldQuery.where().name().isLike("my task name");

I would like that such a query returns the tasks which name is "MY Task NAme". Thanks in advance

Emmanuel

Accepted Answer

0

Hi Emmanuel

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 ivy.wf.findTask(...) API. It supports RelationalOperator.EQUAL_IGNORE_CASE and RelationalOperator.NOT_EQUAL_IGNORE_CASE operations.

link

answered 20.08.2015 at 17:03

Reto Weiss ♦♦
4.9k●20●28●57
accept rate: 74%

Answer 2

0	Hi Reto, This question is answered 2 years ago. How about now, is there any improve and update on this problem? Thanks, Mr. DK link answered 15.03.2017 at 05:01 khanh11166 (suspended) accept rate: 0%

Answer 3

0

Hi Mr. DK

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.

If you have access to our confluence then the following page may also help you: https://jira.axonivy.com/confluence/display/XIVY/Case+insensitive+LIKE+operations

link

answered 15.03.2017 at 08:42

Reto Weiss ♦♦
4.9k●20●28●57
accept rate: 74%

Hi Reto, Thanks for getting back to me. I was read this confluence page and see one row for PostgreSQL was mark "Possible", but you said "we are still investigating how we can solve the problem"

I'm confused now. Could you explain a little bit more about it?

For my situation, we have the plan to upgrade to Ivy 7.0 (not 6.5), can this version of Ivy support us on working case-insensitive?

Thanks, Mr. DK

(16.03.2017 at 04:28) khanh11166

Hi Mr. DK

Yes it says its possible to set a collation on the database. But unfortunately there is no case insensitive collation available for PostgreSQL. So at the moment we do not have a solution for PostgreSQL. We are trying to solve the problem till 7.0. But I cannot promise that it will be solved.

(16.03.2017 at 08:51) Reto Weiss ♦♦

TaskQuery case insensitive search

Follow this question

Related questions