Jump to content

Multiple values on one line in an 'Or Contains' statement

Recommended Posts

I'm setting up a ticket which will be assigned to one specific analyst within a team based on the Division selected in the Progressive Capture.

So, if the Division selected is Div A, then it will be assigned to Analyst A

If the Division selected is Div B, it will be assigned to Analyst B.

Is there a way of adding MULTIPLE static text options to one OR statement? So, if the Division selected is Div C OR Div D, then it will be assigned to Analyst C.

Obviously I can add these OR statements one at a time, but we have 28 different divisions and 5 different analysts, so adding each Division one at a time as part of a Custom Expression is really time consuming. Can I separate each variable by commas or semi-colons or something, or do I have to add each option separately? 


Hope that makes sense.....




Link to comment
Share on other sites

  • 2 months later...

@Paul Alexander,

So i have added ability to test many values inline using OR . The OR is case sensitive so has to be CAPS and have space either side. So in the value field you could do var = "hardware OR laptop OR desktop". I also added support for AND, so could do var != "hardware AND laptop AND desktop" .... you cannot mix the OR and AND as that would, well, be having an inline expression engine in expression builder.

Note you also apear tyo be on older version of admin tool as you do not have the new customer expression dialog (as attached).

Anyway will put this change through dev and beta then push to live around this time next week.



Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
  • Create New...