JIRA JQL Cheat Sheet
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"