We are currently performing maintenance on Appian Community. As a result, discussions posts and replies are temporarily unavailable. We appreciate your patience.
Hi All,
i have a query related to logical expression
as you can see their is a logic mentioned in below code which is i am using in a database table but now i need to use this logic in expression rule to show grid field so any one can help me to implement this logic or you can give any example
we requird the filter on below case where status
in('Started','Pending','Suspended','Resumed','On Going') OR ( in('Cancelled','Completed')AND ModifiedDate >= (GETDATE()-7))
Discussion posts and replies are publicly visible
You can do this with the QueryLogicalExpression feature of Appian queries - you merely need to nest your LogicalExpressions (they can luckily be nested basically to any level). In your case you'd have a parent logicalExpression with the "OR" operator, a query filter with your left condition, then a child logical expression with the "AND" operator and two queryFilters (one for the status and one for the modified date).
thankyou