JQL Query

[Md Ghaus Ali]

Hi All,

Can someone please help me on what will be the JQL to filter the User Story(US) that have been deployed during one week? Can we write a JQL for this?

One condition we can use is that an US status changes from “Ready for Deployment” to “Deployed”, if we can leverage this to filter out.

Please help !!!

Thanks in advance !

[Trudy Claspill · Accepted solution]

Hello @Md Ghaus Ali 

Welcome to the community.

Is the "Deployed" status your final status in the workflow? Is it the only green status (the only "done" status) for your workflow?

If it is the only "done" status for your workflow, then the Resolution Date field should be getting set when issues transition to that status, and you could write a filter to check for issues where the Resolution Date is in the past week:

resolutionDate >= -1w

[Md Ghaus Ali]

No, Deployed is not the final one. 
Completed is the final one. 

so what my requirement is that I want to filter out all the stories whose status were changed from "Ready for Deployment" to "Deployed" in past one week for a particular project i.e. project = XYZ AND ...... {further conditions go after this}.

Thanks !

[Trudy Claspill]

Do you care what status the issue is currently in? If it was transitioned to Deploy in the past week and then also transitioned to Completed, and possibly re-opened (if that is a status it can go to after Completed) would you still want the issue in your results set?

You can use the WAS operator to check for a value that the Status field "was" assigned during a time period. Refer to

https://support.atlassian.com/jira-software-cloud/docs/advanced-search-reference-jql-operators/#Advancedsearchingoperatorsreference-WASWAS

If you care about the current Status of the issue, you would want to add a condition to check that too.

[Md Ghaus Ali]

@Trudy Claspill : I prepared the below JQL based on the link you shared :- 

Project = XYZ AND Status changed from "Ready for Deployment" to "Deployed" during (2022-07-25, 2022-07-31) ORDER BY fixVersion ASC, issuetype ASC

Can you please confirm if this is right?

[Trudy Claspill]

@Md Ghaus Ali 

It appears correct. CHANGED is another operator you could use to get the results.

[Md Ghaus Ali]

Thanks for confirming.