Useful Advanced Jira Queries (JQL) for Scrum Project Management (in an active sprint)

While a digital project/product manager is managing a scrum project the queries that below could be useful to view active sprint tasks and other necessary details.

DEVELOPER TEAM - ACTIVE SPRINT

(Active Sprint Assigned Tasks)

To Do:

project = "Your Project Name/ID" AND status = “To Do” AND Sprint in openSprints() AND Sprint not in futureSprints() AND assignee in (THE ASSIGNEE ID OF DEVELOPER)

In Progress:

project = "Your Project Name/ID" AND status = “In Progress” AND Sprint in openSprints() AND Sprint not in futureSprints() AND assignee in (THE ASSIGNEE ID OF DEVELOPER)

Wait For Deployment:

project = "Your Project Name/ID" AND status = “Wait For Deployment” AND Sprint in openSprints() AND Sprint not in futureSprints() AND assignee in (THE ASSIGNEE ID OF DEVELOPER)

Wait For Prod Deployment:

project = "Your Project Name/ID" AND status = “Wait For Prod Deployment” AND Sprint in openSprints() AND Sprint not in futureSprints() AND assignee in (THE ASSIGNEE ID OF DEVELOPER)

QA TEAM — ACTIVE SPRINT

(Active Sprint Assigned Tasks)

Ready To Test:

project = "Your Project Name/ID" AND status = “Ready To Test” AND Sprint in openSprints() AND Sprint not in futureSprints() AND assignee in (THE ASSIGNEE ID OF QA TEAM MEMBER)

Ready To Prod Test:

project = "Your Project Name/ID" AND status = “Ready To Prod Test” AND Sprint in openSprints() AND Sprint not in futureSprints() AND assignee in (THE ASSIGNEE ID OF QA TEAM MEMBER)

— — — — — — — — — — — — — — — — — — — — — — — — — — — — — — —

Now go to the issue navigator. Copy the Jira Queries above then paste it on input area.

--

--

Get the Medium app

A button that says 'Download on the App Store', and if clicked it will lead you to the iOS App store
A button that says 'Get it on, Google Play', and if clicked it will lead you to the Google Play store