Hi all, Is it possible to search against String Task properties with a TaskQuery so that the search is performed case insensitive.
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 |
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 answered 20.08.2015 at 17:03 Reto Weiss ♦♦ |
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 |
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 Weiss ♦♦ 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 ♦♦
|
Once you sign in you will be able to subscribe for any updates here
By RSS:Markdown Basics
Tags:
Asked: 14.08.2015 at 16:36
Seen: 3,221 times
Last updated: 16.03.2017 at 08:51