Issue with jql filter on a custom field

[momo adc]

Hello!
I have a jql filter that checks whether a user is a value of a multi user picker custom field. for some reason the filter consider the user as a value even if it's not, which cause issues in the filter. What can I do?

[Marc - Devoteam]

Hi @momo adc 

Welcome to the community.

On asking a question on a filter, show the JQL of the filter.

What is the outcome and how is that not as expected?

[momo adc]

The filter is a quick filter in a board, it suppose to show the user an issue under in review status if the user is a reviewer (also a custom field) and not under "reviewed by" field.

The jql: "cf[118030] (reviewer) = <user> AND status = in review AND NOT "reviewed by" = <user>"

It doesn't show the issue even if the JQL should be correct, I believe its because of the reviewed by field, because without this part in the JQL, it does show the issue under the filter.

[Marc - Devoteam]

HI @momo adc 

What if you refrase the JQL to:

cf[118030] (reviewer) = <user> AND status = "in review" AND "reviewed by" != <user>

[momo adc]

I tried it already, still doesn't work. :(

Also thank you for the help!

[Marc - Devoteam]

Hi @momo adc 

Or change the JQL to (based on that the field "reviewed by" is always populated):

cf[118030] (reviewer) = <user> AND status = "in review" AND ("reviewed by" != <user> or "reviewed by" is not empty)

[momo adc]

Still no....

[Marc - Devoteam]

Hi @momo adc 

As I mentioned is the field "reviewed by" always populated or. an it be empty

Can you show the board config and the filter used on the board?

[momo adc]

Oh sorry, it can be empty. what do you want to see in the board configuration?

[Marc - Devoteam]

Hi @momo adc 

How is you board configured, what is the filter that is used on the board? This could impact the JQL you could use in a quick filter.

But as you mentioned the field value could be empty.

cf[118030] (reviewer) = <user> AND status = "in review" AND (("reviewed by" != <user> and "reviewed by" is not empty) or ("reviewed by" !=  <user> and "reviewed by" is empty))

[momo adc]

Hello!

The filter that is used on the board is: (project =  <project name> AND type != epic) or (project = <another project's name and support team = <team name>) ORDERED BY priority DESC

I don't believe that the board filter is the issue because those issues are exist in the board, just not being displayed on quick filters