Customize the sort functionality.
How to customize the sort functionality.
Scenario 1: When sort on a column of a grid for which report definition is input, the Capital letters sorted first then small letters comes into picture. This is the default behavior of the DB since the sorting is based on ASCII values of characters. Is there any way to sort by case independent with out changing the setting (NLS_SORT) in the DB.
Scenario 2: For some columns there is a control which displays different value in the gird as compared to clipboard (Ex. Code on the clipboard and showing description on the UI). Now the sorting will work on clipboard values instead of formatted values but i want to sort on formatted values.
I tried using pyPostGridUpdate activity to customize the sort functionality for both the scenarios but it seems not working.