Hi there,
I have a record type, want to show the time date either is null or earlier than today. Could anyone here how to combine these two filters together?
a!queryFilter( field: 'recordType!{30a8a442-d786-4e84-a096-714b5ce3577a}CPD_peng_test.fields.{countedTime}countedTime', operator: "is null" )
a!queryFilter( field: 'recordType!{30a8a442-d786-4e84-a096-714b5ce3577a}CPD_peng_test.fields.{countedTime}countedTime', operator: "<", value: todatetime(today()) )
regards,
Lin
Discussion posts and replies are publicly visible
Hi , you can use query logical expression to combine the filters. Check out the link below to see how can we use logical expression,
Got it, thank you.
and more, if i have three filters A, B, C, and I want to have the something like A AND (B OR C), how to implement it?
You can write logical expression inside logical expression parameter, meaning you can have two logical expressions one for A and another for B ,C
Please refer to the example at https://docs.appian.com/suite/help/22.1/Query_Recipes.html#querying-on-nested-conditions
got it working, thanks