question related to logical Expression Rule

Question

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

Mike Schmitt · Accepted Answer

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).

Prasanta Paul · Answer

a!queryRecordType(
 recordType: recordType!abc,
 fields: a!queryLogicalExpression(
 operator: "OR",
 filters: {
 a!queryFilter(
 field: recordType!abc.xyz,
 operator: "in",
 value: "Started"
 )
 }
 )
) 
 Like that you can continue the queryFilter to get the value.

question related to logical Expression Rule

Top Replies