Question

1
Replies
1004
Views
SaurabhG2392 Member since 2013 24 posts
Accenture
Posted: 3 years ago
Last activity: 3 years ago
Closed

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***

Case Management Reporting
Moderation Team has archived post
Share this page LinkedIn