How can I remove duplicated issue keys from a query result

Question

Hi all, I'm trying to run the following query, but I'm getting The issue key 'Duplicate' for field 'issuekey' is invalid. project = AND component = AND ("Traceability Relevant" = Yes OR labels = ) AND status != Inactive AND (fixVersion != AND fixVersion != AND fixVersion != AND fixVersion is EMPTY) AND issuekey != Duplicate How can I remove duplicated issue keys in the query result? Also, I tried to use != and !~ in as a list to have a clean query, but it's not accepted: Operator '!=' does not support the list value '("v1", v2","v3)' for field 'fixVersion'. I'm using Jira v7.13.8 Thanks!

Nic Brough -Adaptavist- · Answer

No.  JQL returns a list of issues that matches the question of "what issues match these criteria".  It has nothing to say about what you report on or how.

Lonnie_q4w3ja · Answer

Is there JQL syntax which post-processes a query fragment to remove duplicated column values? For example: `project = MINE and assignee order by assignee UNIQ`

or something like that.

Nic Brough -Adaptavist- · Answer

You say "I need to remove duplicated issue keys [from a search result]"

Actually, no, you do not.  Jira already de-duplicates the list.   You are not getting the same issue key in the results.

The only way you might, which is rare, is when you have a very badly damaged index.  If that is the case, you desperately need to find out what is corrupting it, fix that, then run a full locking re-index.  Your duplicates will then vanish from your search results.

I'd be interested to see a screenshot of what is making you think you have duplicates.