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"

Sign up to discover human stories that deepen your understanding of the world.

Free

Distraction-free reading. No ads.

Organize your knowledge with lists and highlights.

Tell your story. Find your audience.

Membership

Read member-only stories

Support writers you read most

Earn money for your writing

Listen to audio narrations

Read offline with the Medium app

--

--

Responses (1)

Write a response