nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

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 !

Accepted answers

Trudy P Claspill

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

All comments

Trudy P Claspill

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?

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 P 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 P 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?

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

jira

cloud

jira-cloud

jql