Skip to main content
Known Participant
April 7, 2022
Question

how to "OR" two filters in record type

  • April 7, 2022
  • 7 replies
  • 6 views

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

7 replies

gopalk2865
Participating Frequently
April 7, 2022

Hi , you can use query logical expression to combine the filters. Check out the link below to see how can we use logical expression,

[View:https://docs.appian.com/suite/help/21.3/Query_Recipes.html]

linp0001Author
Known Participant
April 7, 2022

Got it, thank you.

linp0001Author
Known Participant
April 7, 2022

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?

gopalk2865
Participating Frequently
April 7, 2022

You can write logical expression inside logical expression parameter, meaning you can have two logical expressions one for A and another for B ,C

linp0001Author
Known Participant
April 7, 2022

got it working, thanks