Useful Advanced Jira Queries(JQL) for Sprint Reports
2 min readJun 24, 2020
Useful advaced Jira queries sometimes are needed to know how it’s going on.
So we may need to know the performance of the team members in daily, weekly or in a specific time period.
What a team member such as developer or qa member is completed or failed and also how many tasks, issues are solved and more.
SPRINT REPORT
Created Tasks:
- “Created >= date AND Created <= date”
project = "Your Project Name/ID"AND created >= 2019-01-31 AND created <= 2019-02-15 AND status was "To Do"
Completed Tasks:
- “Status Changed During () to () from () to ()”
project = "Your Project Name/ID" AND status changed during (2019-01-31, 2019-02-15)
from "Ready to Prod Test" to ("Done","Closed")
by (THE ASSIGNEE ID OF DEVELOPER) OR status changed during (2019-01-31, 2019-02-15)
from ("To Do","In Progress","Wait For Test Deployment","Ready To Test","Wait For Prod Deployment","Ready To Prod Test", "Wait For Release") to ("Done")
by (THE IDs OF STATUS CHANGER OF THESE TASKS)
Removed Tasks (Removed from sprint):
- “Status Was in () during ()”
- “Status Changed During () to () from () to ()”
project = "Your Project Name/ID"AND status was in ("To Do", "In Progress") during (2019-01-31, 2019-02-15)ANDstatus changed during (2019-01-31, 2019-02-15)
from ("To Do","In Progress") to ("Backlog")
Closed Tasks:
- “Status Was in () during ()”
- “Status Changed During () to () from () to ()”
project = "Your Project Name/ID"AND status was in ("To Do", "In Progress") during (2019-01-31, 2019-02-15)ANDstatus changed during (2019-01-31, 2019-02-15)
from ("To Do","In Progress") to ("Closed")
