nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

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.

Accepted answers

Gor Greyan

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.

All comments

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.