We are trying to validate the Sorting on Grid Columns
For this we are fetching the data of the column from DOM using web scraping
Example:
Column1: "Apple", "Apple1", "Apple0", "Apple_"
on sorting the Grid (say in Descending Order)
We get:
Column1: "Apple1", "Apple0", "Apple_", "Apple"
Which tells us that the order of preference when sorting is:
'1' > '0' > '_' > ''
But the ASCII values are:
Character - ASCII Value
1 - 49
0 - 48
_ - 95
Hence going by ASCII Values
'_' must have the highest preference
and the sorted column data must be
Column1: "Apple_", "Apple1", "Apple0", "Apple"
Does anyone know what could be the reason behind it?Does Appian Sort by ASCII Characters or it has some other methodology ?Thank you
Discussion posts and replies are publicly visible