Joget DX 8 Stable Released
The stable release for Joget DX 8 is now available, with a focus on UX and Governance.
Hi, I believe the current implementation of the plugin is to cater for different database behaviors but yes, there should be an option to disable it. Until that is added I think you would need to extend it with your own implementation though.
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.