Trouble getting filter to work properly for 2 boards within same project

[Zack Mosbrucker]

The ‘MES Board’ is the main one we use within the "MES" project and the query is pretty simple.

project = MES AND issuetype in (Bug, Epic, Story, Sub-task) ORDER BY Rank ASC

The ‘MES Plant Board’ is the new one we have created.  It is the same but has a custom field that I am using to say if it goes on the Plant board.

project = MES AND issuetype in  (Bug, Epic, Story, Sub-task) AND "MES Activity" = "Plant Scaling" ORDER BY Rank ASC

The issue I am having is when I try to update the MES board so that it does not show anything that should be on the plant board, it removes a bunch of the issues from the MES board.  I cannot figure out why I cannot just say anything that is not “Plant Scaling”.  This is as close as I was able to get with the query.  I feel like it doesn’t handle custom fields that well.  

project = MES AND issuetype in (Bug, Epic, Story, Sub-task) AND ("MES Activity" not in ("Plant Scaling") OR "MES Activity" is EMPTY) ORDER BY Rank ASC

What am I missing here?

[Thomas Deiler · Accepted solution]

Dear @Zack Mosbrucker ,

welcome to the community!

What custom field type is "MES Activity"?

So long

Thomas

[Zack Mosbrucker]

Hello Thomas - It is a Select List (single choice).

[Thomas Deiler]

The following worked for me:

project = TSK AND ("MES Activity" is empty or "MES Activity" not in ("Plant Scaling"))

and the opposite

project = TSK AND "MES Activity" in ("Plant Scaling")

I had to re-index to get work, after I introduced the new custom field.

In your upper JQLs you also specify issue types. Make sure that all issue types can edit/view this custom field.

(tested on Jira 8.13.2)

[Zack Mosbrucker]

Re-indexing did the trick. Thank you!