Jira Advanced Search help needed!

Philip Culver

This is my Jira board query:

project in (FP, FNA) OR labels in (native) AND labels not in (not-active) ORDER BY key DESC, Rank ASC

There is an issue in the FP project with the 'not-active' label that is showing in the result set.

 

What am I doing wrong...?

Mikael Sandberg

Its because of how you constructed your query, it currently says get everything in project FP and FNA, or look for issues with the native label and not not-active. Instead your query should look something like this, assuming you want to limit your search to FP and FNA:

project in (FP, FNA) AND (labels in (native) AND labels not in (not-active)) ORDER BY key DESC, Rank ASC