Jira JQL Queries

Advanced Searching Documentation

issueFunction in linkedIssuesOf("filter=10538", "is epic of")

resolution = Unresolved AND issueLinkType = remediates ORDER BY Rank ASC

filter = 10519 OR filter = 10520 OR filter = 10521 OR filter = 10522 OR filter = 10523 OR filter = 10524

statusCategory != Done AND resolution != Unresolved

issuetype = Epic AND resolution = Unresolved AND labels = project OR type = Epic AND issueFunction in hasLinks(implements)

issuetype = Epic AND statusCategory = "In Progress" AND issueFunction not in hasLinkType("Epic-Story Link")

timespent is EMPTY AND assignee = currentuser() AND resolution != Unresolved AND resolutiondate > -14d

issuetype = Epic AND assignee in (membersOf(sda-it-all))

issuetype = Epic AND issueFunction not in hasLinkType("Epic-Story Link")

type = Epic AND issueFunction in hasLinks(implements) AND labels = project

issueFunction in linkedIssuesOf("key = INITIATIVE-1", "is implemented by")

issuefunction in linkedIssuesOf("filter='Initiative Epics (INITIATIVE-1)'", "is Epic of")

issueFunction in linkedIssuesOf("key = INITIATIVE-1", "is implemented by") OR issuefunction in linkedIssuesOf("filter='Initiative Epics (INITIATIVE-1)'", "is Epic of") OR issueFunction in subtasksOf("filter ='Initiative Issues (INITIATIVE-1)'") ORDER BY Rank ASC

development[commits].all > 0

development[branches].all > 0

All issues in projects where Jeff is the Jira Project Lead: project in projectFieldsQuery("lead = 'vailj'")

project in projectFieldsQuery("lead = vailj") AND project in projectFieldsQuery("Supports IN ('app support' , 'coding work')") AND resolution = Unresolved AND assignee is EMPTY

How to write JQL that encompasses all of the issues in an initiative

SLAs

priority = High and "Time to first response" = breached()

priority = High and "Time to first response" != breached()

Linked Issues

issueLinkType in (blocks, causes)

https://jamieechlin.atlassian.net/wiki/spaces/GRV/pages/33030163/Scripted+JQL+Functions#ScriptedJQLFunctions-linkedIssuesOf%28Subquery,linkname%29

Scripted JQL Quick Reference Guide by Adaptavist

Scripted-JQL-Quick-Reference-Guide.pdf