how to get null values last in report definition sort when column sort is highest to lowest?
created search functionality where need to show the record based on completion date - Highest to Lowest
Added filter condition on pyResolvedTimestamp as highest to lowest in the report definition.
now null cases(not yet resolved) are coming on top instead of showing the latest resolved task first.
As checked on google by default null records will come first but we can add "order by PYRESOLVEDTIMESTAMP DESC NULLS LAST" in oracle for the correct ordering. Is this option is available in the Pega report definition for null values?
select pyid, PYRESOLVEDTIMESTAMP from APP_WORK order by PYRESOLVEDTIMESTAMP DESC NULLS LAST ;
How we can achieve this requirement by report definition in Pega?
Lantiqx
GB
@Deven ,
I don't think there is any config to add "NULLS LAST" for sorting the columns. May be we can expect this in next releases.
As of now we can use "Override Sort Function" configuration available on property rule. Check pyID property for reference.
Thanks
Krishna