User Filter on multiple values

anjup over 7 years ago

I have a requirement to filter entity backed record using Static User Filter.
Scenario: List of status: {"a","b","c","d","e","f"}. I have to exclude "e" & "f" by using single static filter. I tried using "<>" operator ,but it was not working .Is there any way I can achieve it.

Thanks in advance

Discussion posts and replies are publicly visible

Parents

0 santhoshp523 over 7 years ago

create a rule as below
isReject = or(ri!status="e", ri!status="f")

a!queryFilter(
field: "status",
operator: "=",
value: reject(rule!isReject(_), ri!statusList)
)
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Reply

0 santhoshp523 over 7 years ago

create a rule as below
isReject = or(ri!status="e", ri!status="f")

a!queryFilter(
field: "status",
operator: "=",
value: reject(rule!isReject(_), ri!statusList)
)
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Children

No Data