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