option to use TextFieldDataListFilter without lower() for faster search
Confluence User - 13 Jul, 2020
the TextFieldDataListFilter creates a where clause ' where lower(" + cname + ") like lower(?)'
This where clause is slow on the SQL server with large tables because the DB index cannot be used with lower().
Is there a way to have the where clause without 'lower()' ? The SQL server uses by default case insensitive search so the lower() makes no difference in the search result, it is just slower.
Of cause I could write my own plugin, but here an option on the TextFieldDataListFilter to not use lower() may help also other customers.
datalists;filters