JQL for MultiSelect Field

[Gor Greyan]

Hi, Dear Community!

I have a Partner multi-select field.

I have automation, which should provide access when the Partner name, for example, X.

But it should not provide access when the partner name is X, Y, Z, only when it is X.

Couldn't get the JQL, which will work only in that case.

Also can't exclude the rest partner's name, as there are more than 100 values.

Thanks in advance.

[Gor Greyan · Accepted solution]

Hi @arielei

I have found another simple solution, via the conditions.

I put 2 conditions.

1. {{issue.customfield_11735.size}} is grather than 0

2. {{issue.Partner.value.join("|")}} exactly matches the Regular Expression, and my Partner names with Reg-ex.

This worked.

[arielei]

@Gor Greyan 

Excellent - just make sure its compatible with Cloud as you will soon need to migrate to cloud.

If not, the solution i wrote you by using automation is supported in cloud.

[arielei]

Hello @Gor Greyan 
Try the following JQL

"Partner name" = X and "Partner name" not in (Y,Z)

This would give you the result you want.

Ariel. 

[Gor Greyan]

Hi @arielei

Thanks for the answer, but as I mentioned, I can't exclude the rest values, as I have more than 100 values, and it is being added again and again.

[arielei]

Hey @Gor Greyan 

I understand you issue.

So what i would do is:

1. Create a JQL filter.

after that:
1. Create an schedule automation

2. Run a branch on JQL: "Partner Name" = X

2. Do if on branch if {{issue.Partner name.size}} equals 1

3. add it to var.

Then, run a web rest api call to update the saved filter with those values.

so for example, the filter will be: "Key in (A-1,A-2,A-3)".

keep in mind that you will probably need to do some adjustments on the syntax before saving it as a filter.

Hope that helps.

Ariel.