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

asked 14.08.2015 at 16:36

Emmanuel's gravatar image

Emmanuel
(suspended)
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.

link

answered 20.08.2015 at 17:03

Reto%20Weiss's gravatar image

Reto Weiss ♦♦
4.9k202857
accept rate: 74%

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%20Weiss's gravatar image

Reto Weiss ♦♦
4.9k202857
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

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's gravatar image

khanh11166
(suspended)
accept rate: 0%

Follow this question

By Email:

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

By RSS:

Answers

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

Tags:

×13
×10
×3

Asked: 14.08.2015 at 16:36

Seen: 3,221 times

Last updated: 16.03.2017 at 08:51