Question

9
Replies
3277
Views
Close popover
SatishKumar Tanappa (Satish)
Optus
Lead Developer
Optus
AU
Satish Member since 2012 17 posts
Optus
Posted: November 16, 2015
Last activity: February 8, 2016
Closed

Customize the sort functionality.

Hi Team,

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.

Regards,

Satish

Reporting
Moderation Team has archived post