DEV Community

Lorna Watson
Lorna Watson

Posted on • Updated on

Useful JQL (Jira Query Language) Dump

I'm playing around with JQL to see what interesting data I can get back from Jira. I'll keep this page updates with more queries as I find them.

Overview and some useful bits:

  • DevProject is an example project and DP being the ID of it
  • DP-Avengers is a team name
  • summary ~ help issues that contains help in summary
  • labels = TechDebt issues with label TechDebt

Links:

Description JQL
List of DevProject tasks with no assignee, open status and was last updated more than 4 weeks ago project = DP AND assignee is EMPTY and status = OPEN and updatedDate <= -4w
List of DevProject issues created this week project = DP AND created > startOfWeek() and created < endOfWeek()
List of DevProject issues created this year project = DP AND created >= startOfYear()
List of DevProject bugs created this year project = DP AND created >= startOfYear() AND issuetype = Bug
List of DevProject issues created this year and still open project = DP AND created >= startOfYear() AND status = open
List of DevProject support tickets in open sprints project = DP AND issuetype = "Support Ticket" AND Sprint in openSprints()
List of open DevProject issues order by oldest first project = DP AND status not in(Complete, Closed, Resolved, Done, Declined) ORDER BY created ASC
List of top severity issues in DevProject for Team Avengers created since start of month project = DP AND priority = "Sev 1" AND "Engineering Team[Dropdown]" = DP-Avengers AND created >= startOfMonth()
List of level 3 severity issues in DevProject since start of year project = DP AND priority = "Sev 3" AND created >= startOfYear()
List of issues in current sprint in DevProject with a story point assigned order by largest value project = DP AND sprint in openSprints() AND "Story Points[Number]" IS NOT EMPTY ORDER BY cf[10003] DESC
List of in progress issues in DevProject with empty assignee project = DP AND statusCategory = "In Progress" AND assignee IS EMPTY

Top comments (0)