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.