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

[Paul Alexander]

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.....

 

thanks

[Victor]

This would be something that @NeilWJ can advise on?

[NeilWJ]

Hi @Paul Alexander,

Yup that makes sense. Not currently possible. Thinking maybe can add a [+] btn next to delete btn so when clicked adds another value to test. I will have a look at it tomorrow (its night time here in oz) and let you know how i get on.

Cheers

[NeilWJ]

@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.

Cheers

[Paul Alexander]

Hi @NeilWJ

 

thanks for that...I look forward to seeing it all in action! 

I can't see the image you uploaded, but I thought the admin tool updated automatically as and when and update was available? Do I need to do something to get this sorted?

 

thanks again

 

Paul

[NeilWJ]

@Paul Alexander,

Let me try upload image again. Let me know if you can see it this time.

Regarding admin tool version, yes i believe you just get the latest version automatically when we push it live. I will dbl check with cloud team.

Cheers

[Victor]

2 hours ago, Paul Alexander said:

Do I need to do something to get this sorted?

[Paul Alexander]

Hi @NeilWJ - yes I can see that image thanks...and it all makes sense!

@Victor.....we  ALL know that the only reason we ask that is that, while it's being rebooted, we IT Geeks can use that time to google the actual problem so that we have an idea of how to fix it.....or is that just me?! 

[Victor]

@Paul Alexander ...