Filtering based on the reason for resolution

Question

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 Answer

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. ;)

Ravi Sagar _Sparxsys_ · Accepted Answer

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