Incorrect results display when sorting the Currency column
Incorrect results display when sorting the Currency column in a repeating grid.
Steps to Reproduce
- Log in to the application
- Configure a repeating grid heading that is enabled for sorting the values
- Click the 'Charges' column header to sort
An issue in the custom application code or rules. The .Charges property represented by the grid column is of type Text.
The corresponding data type of the database column is varchar.
Here’s the explanation for the reported behavior:
The grid sort is accomplished by retrieving the results from the database with an 'ORDER BY' clause on the sort column. Since the column data type is varchar, the values are sorted as strings.