Question
Accenture
US
Last activity: 9 Oct 2017 5:59 EDT
Function to replace declare expression
Hi All,
I am referring property in report definition which is calculated through declare expression. because of which sorting and filter is not working on it.
I want to replace declare expression with function. Can someone help on how can i write function replace below declare expression condition?
.Age = @DifferenceinDays(.pyResolvedTimeStamp, @CurrentDateTime()) ---- if pyResolvedTimeStamp is not null
.Age = @CurrentDateTime() ---- if pyResolvedTimeStamp is null
Any suggestions are greatly appreciated.
***10/3/17 Edited by moderator, Maryrita: moved to Product Support from Applications***
***Edited by Moderator Marissa to update categories***
Pegasystems Inc.
IN
Hello,
You can use the function @DifferenceinDays in the report definition itself.
This function returns the the second value minus the first value in days. So if .pyResolvedTimeStamp has a value 0, it would still give the currect result (date2-0).
Or you could save as the function alias pxDifferenceInDays to your ruleset and modify the Source accordingly.
Thanks,
Gisela