Jinja Expression for Duration (Days) > 100
Working a seeming simple pipeline to search casework, where [case age] is greater than 100 days. [case age] is a duration between two dates expressed in Days.
In the pipeline, when querying the search records
The results are much more than expected. When reviewing the pipeline activity logs, I can see the case_age is not in the same format as 123 Days.
logs show -
status:"O-In-Progress"
case_age:108862912
Clearly, pipelines doesn't recognized duration values as simple numerical values.
I cannot seem to master the correct expression that evaluates to "True"
Any help in this matter would be appreciated.
------------------------------
Thank you,
Chuck
------------------------------
