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
Sorting is typically done in the DB and based on the selected collation.
oh I see,So when the Data is coming from DB, the Sorting is applied at DB Level itself and not at Appian interface grid column even though we sort the GRID by clicking on Column Header.Thanks Stefan
Correct, Appian's sorting is done merely by passing the column name to be sorted into the DB and then displaying the value of the resulting query.