Symptoms

How to configure search in K2 list view to ignore upper case andamp lower case?

Now, my transaction DB set collation as CS_AI but I want to set K2 view list able to search both upper or lower case instead of changing the DB's collation.

 

Diagnoses

There is currently no properties to configure to get the search and filter to ignore case if your database collation is case sensitive.

 

Resolution

A possible workaround is to create a stored procedure to list your results. You can specify which collation you want to use for a particular column in your SELECT query. Next, you can add that stored procedure as an alternative List method to your SmartObject, and you can use that instead to list the results in your View.