question to confirm my JQL for a mult-select field

[Stu]

Hi, I have made a custom multi-select field in my task screen, to distinguish between task types.   So most issues won't have anything selected in this field, but some will.

I want to create a JQL query on this field to return all the issues that have a selection on this multi-select field.  So for example, my field is called 'workshop' and the options to choose in the drop-down are 'risk', 'design thinking' and 'compliance'.

I was thinking that the following JQL would work...

workshop = "risk" OR "design thinking" OR "compliance"

but this isn't working for me.  Any suggestions?

[Thomas Deiler · Accepted solution]

Dear @Stu,

you JQL's syntax is wrong. You can only compare a field with a fixed value or function.

It has to be

workshop = "risk" OR workshop = "design thinking" OR workshop ="compliance"

So long

Thomas

[Stu]

awesome thanks

[Thomas Deiler]

Dear @Stu,

was my answer good enough to be accepted?

Many thanks

Thomas

[Stu]

yes it was, how do it do that?  I gave it a vote.  Cheers

[Thomas Deiler]

A little bit left of the vote button (hover over). There you can set a green check.

Vote and accept are different.

Many thanks

Thomas