Case Insensitive Sorting in Servoy DataGrid

Classic Servoy
1

Hi,

I am working on NG Client and creating UI which is utilizing Servoy NG-Grids → DataGrid.

Foundset which is bound to DataGrid contains following fields of interest:

  • Text field (for Title of product. Product title has some entries which are starting with small letters and some with Capital letters.)
  • Text field (for description/detail of product)
  • Number (for stock quantity available)
  • Date (for date of last stock updated)

I have successfully mapped these fields in DataGrid and it displays my data as required.

But when it comes to sort on basis of Product Title (as mentioned earlier product title may start with small letter or capital letter), result is unacceptable because sorting done is case sensitive. i.e. A, B, C,…Z, a, b, c…,z. Actual requirement is to sort case insensitive. i.e. A, a, B, b, C, c, …Z, z.

Any assistance in resolving above will be highly appreciated.

Thanks

2

See case SVY-12272: is a limitation of Servoy