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?