Versions Compared

Version Old Version 2 New Version Current
Changes made by

Erin Kilburn

Erin Kilburn

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Info

Update all of these queries to reference your project or filter of projects, then delete this info section. 

This query shows all issues estimated over 20 hours (excluding tasks associated with sessions), to be updated to ensure compliance with the SPM framework. 

type = task AND originalEstimate > 20 ORDER BY originalEstimate DESC, timespent DESCAND issueFunction in issuesInEpics("Object_type != Sessions ")

Jira Legacy
serverITS PRO
columnIdsissuekey,summary,created,updated,duedate,assignee,reporter,status,timeoriginalestimate,timespent
columnskey,summary,created,updated,due,assignee,reporter,status,timeoriginalestimate,timespent
maximumIssues20
jqlQuerytype ! = bug task AND created originalEstimate > = -7d AND creator != currentUser() ORDER BY createdDate DESC, project ASC, "epic link" ASC, creator ASC 20 AND issueFunction in issuesInEpics("Object_type != Sessions ")
serverIdebe8394f-6d75-344c-8d9c-717cb778a1eb

...

Jira Legacy
serverITS PRO
columnIdsissuekey,summary,duedate,assignee,reporter,status
columnskey,summary,due,assignee,reporter,status
maximumIssues20
jqlQueryissuetype = Epic AND status not in (Closed) AND issueFunction in epicsOf("issuetype in (Task,Story,Bug)") AND issueFunction not in epicsOf("status != Closed")
serverIdebe8394f-6d75-344c-8d9c-717cb778a1eb


EXC: Open tasks on closed epics

Info

Update all of these queries to reference your project or filter of projects, then delete this info section. 

This query shows all tasks that are associated with closed epics, so the task should also be closed (or the epic reopened, or the task associated with an open epic). 

resolution = empty AND issueFunction in issuesInEpics(" status = closed ") ORDER BY "Epic Link"

Jira Legacy
serverITS PRO
columnIdsissuekey,summary,issuetype,created,updated,duedate,assignee,reporter,priority,status,resolution
columnskey,summary,type,created,updated,due,assignee,reporter,priority,status,resolution
maximumIssues20
jqlQueryproject = ofce and resolution = empty AND issueFunction in issuesInEpics(" status = closed ") ORDER BY "Epic Link"
serverIdebe8394f-6d75-344c-8d9c-717cb778a1eb


EXC: Open tasks associated with "Won't Do" or "Duplicate" epics

Info

Update all of these queries to reference your project or filter of projects, then delete this info section. 

This query shows all tasks that are associated with cancelled epics, so the task should also be cancelled (or the epic reopened, or the task associated with an open epic). 

resolution is EMPTY AND issueFunction in issuesInEpics(" (resolution = \"Won't Do\" or resolution = Duplicate) ") ORDER BY summary

Jira Legacy
serverITS PRO
columnIdsissuekey,summary,duedate,assignee,reporter,status,customfield_10001
columnskey,summary,due,assignee,reporter,status,Epic Link
maximumIssues20
jqlQueryresolution is EMPTY AND issueFunction in issuesInEpics(" (resolution = \"Won't Do\" or resolution = Duplicate) ") ORDER BY summary
serverIdebe8394f-6d75-344c-8d9c-717cb778a1eb


EXC: No Parent Link

Info

Update all of these queries to reference your project or filter of projects, then delete this info section. 

This query shows all epics that are missing a parent link, which is necessary for them to render list correctly in Jira planPlans.

"Parent Link" is EMPTY AND type = Epic ORDER BY project, duedate

Jira Legacy
serverITS PRO
columnIdsissuekey,summary,duedate,assignee,reporter,status
columnskey,summary,due,assignee,reporter,status
maximumIssues20
jqlQueryresolution "Parent Link" is EMPTY AND issueFunction in issuesInEpics(" (resolution = \"Won't Do\" or resolution = Duplicate) ") ORDER BY summary type = Epic ORDER BY project, duedate
serverIdebe8394f-6d75-344c-8d9c-717cb778a1eb

...