[Ciphered Local Storage Plugin] Case Insensitive Sorting
Forge component by OutSystems R&D
Published on 13 Mar 2020


I am using this plugin. Thank you for providing this.

I see that when I sort an entity on a field, the sort is case-sensitive. I want it to sort case-insensitive.

In the aggregate I am reading data from the database, I am using a 'New Attribute' with 'ToLower(LocalTable.Attribute)' function and then using the name of that new attribute in the Dynamic Sort.

I doubt that my approach is not good from the performance perspective. There could be thousands of rows in the tables I am sorting this way. Is there a better alternative for me to use?

NOTE: I tried 'lower(LocalTable.Attribute)' in Dynamic Sort hoping that lower would be a function in the database. It did not work. Similarly 'COLLATE NOCASE' did not work either in 'Dynamic Sort'.