Filtering based on the reason for resolution

[Tracy Miller]

I would like to be able to filter out a specific reason for why an issue is resolved but cannot figure out the JQL.  If I have the following JQL, where do I add the term to get only the reason I want in resolution?

project in (BLE93100, BLE93960, BLE88030, BLE96330, BLE97870, BLE88880, BLE92040, BLE91050, BLE83110, BLE97060, CLE12690, BLE44100, BLE65380, BLE84500, BLE70640, BLE99680, BLE89920, BLE87680, BLE66900, BLE89600, CRL10380, BLE89000, BLE86390, BLE86830, CLE13190, BLE85970, BLE96970) AND issuetype = Defect ORDER BY resolution ASC, priority DESC, created DESC

[Flavien Gache · Accepted solution]

Hi Tracy.

That would be :

project in (BLE93100, BLE93960, BLE88030, BLE96330, BLE97870, BLE88880, BLE92040, BLE91050, BLE83110, BLE97060, CLE12690, BLE44100, BLE65380, BLE84500, BLE70640, BLE99680, BLE89920, BLE87680, BLE66900, BLE89600, CRL10380, BLE89000, BLE86390, BLE86830, CLE13190, BLE85970, BLE96970) AND issuetype = Defect AND Resolution = Done ORDER BY resolution ASC, priority DESC, created DESC

(that is to say if you want to see all the tickets that have the resolution Done, you can replace it however you want)

I think that should do it, tell me if you succeeded. ;)

[Tracy Miller]

Yes!! Thank you that worked.

[Flavien Gache]

Great ;) Could you please accept my answer so that if other people have a similar request they could find it more easily ?

Thanks in advance.

[Ravi Sagar _Sparxsys_ · Accepted solution]

Hi @Tracy Miller 

May be something like this?

project in (BLE93100, BLE93960, BLE88030, BLE96330, BLE97870, BLE88880, BLE92040, BLE91050, BLE83110, BLE97060, CLE12690, BLE44100, BLE65380, BLE84500, BLE70640, BLE99680, BLE89920, BLE87680, BLE66900, BLE89600, CRL10380, BLE89000, BLE86390, BLE86830, CLE13190, BLE85970, BLE96970) AND issuetype = Defect AND resolution = "Fixed" ORDER BY resolution ASC, priority DESC, created DESC

I hope it helps.

Ravi