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...?
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