[Ciphered Local Storage Plugin] Case Insensitive Sorting

Forge Component
(2)
Published on 27 Feb by OutSystems R&D
2 votes
Published on 27 Feb by OutSystems R&D

Hi,


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'.