How to get text filter case case insensitive?

0
Hello Community,   we use a text filter with Contains in the Data Grid 2.   In the local development environment with HSQLDB this filter works case insensitive. On Test and Pro we have a MS SQL Database with the collation Latin1_General_BIN. In these environments the filter (contains) works case sensitive because of the collation in our MS SQL Database. But also in Test and Pro we should have a case insensitive filter.   Do you know any possibilty/workaround to get the filter (contains) as case insensitive although we have this collation (there are some reasons why it is not possible for us to change the collation on the database).     Any hints are welcome. Thank you very much in advance. Best regards   Uwe
asked
2 answers
1

Hi Uwe,

When you are comparing your text filter text & your retrieval data in the microflow-> first convert the data in the lower case then compare them.

 

toLower(yourData) then  compare them

answered
1

Hi Uwe,

     By default text filter will check by case sensitive, to avoid this try using custom filter by microflow, In that perform the below action to avoid case sentive.

lower($Object/Attribute) = lower($SearchText)

answered