Filter case insensitive

I am using Helical Insight EE 4.1 GA

I have created Adhoc reports using Clickhouse as a datasource. The search option on filters is not case in-sensitive. How can I make the filters search case-insensitive?

Thanks,
Snow.

Hello,

The search option on the filters fires “LIKE” queries on the database tables to search for matches for varchat kind of datatypes. SQL “LIKE” clause is case in-sensitive in many databases but in Clickhouse it is case sensitive. However Clickhouse has a “ILIKE” clause which is case insensitive.

So to make filters search case in-sensitive, make changes to the below files :

Go to : <HI INSTALLATION DIRECTORY>\hi\apache-tomcat-9\webapps\hi-ee\js\adhoc

Make changes to 3 files : report-create.js, report-edit.js, report-open.js

Before changing take backup of these files.

Search for uppercase “LIKE” keyword, it is present at 2 places, change it to “ILIKE”

CHANGE FROM:
this.formData.filters=[{column:col,condition:"CUSTOM",customCondition:"LIKE",values:["%"+term+"%"]}]

CHANGE TO:
this.formData.filters=[{column:col,condition:"CUSTOM",customCondition:"ILIKE",values:["%"+term+"%"]}]

Save the files. Restart is not required. Before testing clear browser cache as it might have a cached version of these js files. Now the filters search will be case in-sensitive in report open window as well as while report create/edit operations.

Thanks,
Helical Insight.