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


asked 14.08.2015 at 16:36

Emmanuel's gravatar image

accept rate: 66%

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.


answered 20.08.2015 at 17:03

Reto%20Weiss's gravatar image

Reto Weiss ♦♦
accept rate: 74%

Hi Reto,

This question is answered 2 years ago. How about now, is there any improve and update on this problem?

Thanks, Mr. DK


answered 15.03.2017 at 05:01

khanh11166's gravatar image

accept rate: 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


answered 15.03.2017 at 08:42

Reto%20Weiss's gravatar image

Reto Weiss ♦♦
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 khanh11166's gravatar image

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 ♦♦ Reto%20Weiss's gravatar image
Your answer
toggle preview

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here



Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text](http://url.com/ "Title")
  • image?![alt text](/path/img.jpg "Title")
  • numbered list: 1. Foo 2. Bar
  • to add a line break simply add two spaces to where you would like the new line to be.
  • basic HTML tags are also supported



Asked: 14.08.2015 at 16:36

Seen: 2,036 times

Last updated: 16.03.2017 at 08:51