2 conditions on same field

stevejones1 — Wed, 25 Nov 2020 16:16:04 GMT

I have a field for Status which has the values 'closed','Confirmresolve','resolved'

i need to create a filter on CaseStatus which should have 2 values CVACLosed and Closed

Closed should include all 3 statuses

CVAClosed should only include 'Closed' and 'Confirmresolve'

How do i write an expression for CaseStatus field?

Thanks!

Re: 2 conditions on same field

Digvijay_Singh — Fri, 02 Mar 2018 23:47:26 GMT

What if you create new island table having field CaseStatus and associate it with field Status like this -

CaseStatus:

Load * inline [

CaseStatus,Status

CVACLosed,Closed

CVACLosed,Confirmresolve

Closed,Closed

Closed,'Confirmresolve'

Closed,'resolved' ];