I want to achieve a jql : remove duplicate assignee

[zhangqian04]

Hi，

      I want a JQL function that can be realized is: in the issue column under a certain condition, you can find the assignee without duplication. For example, there are three issues in the issue, and the assignee are ： A, B ,A ,B ,C. I only need A 、B and C.

    JQL :  project = xxx  AND Sprint = xxx,  this jql query result is:

     issue first :   assignee is A

     issue second:   assignee is B

     issue third:   assignee is A

     issue fourth:  assignee is B

     issue fifth:  assignee is C

     but,I want result is:

     issue first :   assignee is A

     issue second:   assignee is B

      issue fifth:  assignee is C

[Ollie Guan · Accepted solution]

Hi @zhangqian04 ,

Add your vote here.

"Distinct" qualifier in JQL

Or expand the query through the following plugins.

Transform Atlassian's native JQL into industry-standard SQL

[zhangqian04]

I voted this issue  "Distinct" qualifier in JQL    today.

Thanks.