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.