JIRA JQL Cheat Sheet

Bipul Kuri
1 min readAug 16, 2019

--

A good read https://confluence.atlassian.com/jiracore/blog/2015/07/search-jira-like-a-boss-with-jql

How to get next sprint details

project = {MyProject} AND Sprint is not EMPTY AND sprint not in openSprints() AND sprint not in closedSprints()

Give me all User stories in current sprint for which the work started

project = {MyProject} AND Sprint is not EMPTY AND sprint  in openSprints() and issuetype="User Story" and status CHANGED FROM "open"

Give me all Userstories for which there was a change in Assignee in current sprint

project = {MyProject} AND Sprint is not EMPTY AND sprint  in openSprints() and issuetype="User Story" and assignee != NULL and assignee changed

BOUNCING TICKETS

Give me all Userstories for which there was a change in Assignee in current sprint and but no work was done.

project = {MyProject} AND Sprint is not EMPTY AND sprint  in openSprints() and issuetype="User Story" and assignee != NULL and assignee changed  and status="OPEN"

--

--

Responses (1)