Closed raniangamuthu closed 6 months ago
@raniangamuthu please let me know the details. With the image alone, i'm unable to understand the problem here.
If there are null values for any column the sorting when it is done in ascending order it should be listed on the top which is not working like that, this applies to any data type column like string, date etc.,
@ashoksri0 and team please check on this
@raniangamuthu
This is sort behaviour in Excel and we employ the same strategy. null has no value to include for positioning it up or down based on sort order.
Please check and reflect on the above comment. This is not an issue.
Expectation to work as in legacy
Replace null with space and it will get arranaged as you show. try use coalesce function
@raniangamuthu,
Fix for this was provide in the last release ADS v2024.01.45313_P1
Please check and confirm the working and provide closure to the issue
RCA
No specific coding configuration was added on how to treat null or missing values. So it operated on the default mode of keeping null at the end
Fix details
Code modifcation were added to set missing values be put at top if sort is ascending and move it to the last when sorted in descending
Verified and sorting working as expected