Versions Compared

Key

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

...

Info

Update all of these queries to reference your project (put "project = xyz AND " or "filter = 16632 AND " at the beginning of the JQL), then delete this info section. Best practice, review these queries and correct the data on at least a weekly basis. You can also save queries as favorites and subscribe.

If you are managing many Jira projects within a program and single collab page, such as an ESR project, creating a filter to reference all related work you need to monitor is most expedient and allows you to update a single filter if you need to add/remove a Jira project. For example, https://its-pro.ucsd.edu/issues/?filter=16632

*Created Recently Not By Me

Info

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

This query shows all issue types, except bugs, that have been created in your project within the past week. This is useful to ensure that any new issues are associated with the correct epic, in the correct project, etc., because that meta data is not visible in the emailed notification when they are created.

type != bug AND created >= -7d AND creator != currentUser() ORDER BY createdDate DESC, project ASC, "epic link" ASC, creator ASC

Jira Legacy
serverITS PRO
columnIdsissuekey,summary,created,updated,duedate,assignee,reporter,priority,status,customfield_10001,project
columnskey,summary,created,updated,due,assignee,reporter,priority,status,Epic Link,project
maximumIssues20
jqlQuerytype != bug AND created >= -7d AND creator != currentUser() ORDER BY createdDate DESC, project ASC, "epic link" ASC, creator ASC
serverIdebe8394f-6d75-344c-8d9c-717cb778a1eb


EXC: Overdue

Info

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

This query shows all issues that are overdue and need an updated date.

resolution = unresolved AND duedate <= endOfDay() ORDER BY project, assignee, duedate ASC

Jira Legacy
serverITS PRO
columnIdsissuekey,summary,duedate,assignee,reporter,status
columnskey,summary,due,assignee,reporter,status
maximumIssues20
jqlQueryresolution = unresolved AND duedate <= endOfDay() ORDER BY project, assignee, duedate ASC
serverIdebe8394f-6d75-344c-8d9c-717cb778a1eb


EXC: Clean up estimates

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, to be updated to ensure compliance with the SPM framework. 

originalEstimate > 20 ORDER BY originalEstimate DESC, timespent DESC

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 AND created >= -7d AND creator != currentUser() ORDER BY createdDate DESC, project ASC, "epic link" ASC, creator ASC
serverIdebe8394f-6d75-344c-8d9c-717cb778a1eb


EXC: Epic should be closed

Info

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

This query shows all epics where all tasks within are closed, so the epic should also be closed (or more tasks need to be added). 

issuetype = Epic AND status not in (Closed) AND issueFunction in epicsOf("issuetype in (Task,Story,Bug)") AND issueFunction not in epicsOf("status != Closed")

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,duedate,assignee,reporter,status
columnskey,summary,due,assignee,reporter,status
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 correctly in Jira plan.

"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 is EMPTY AND issueFunction in issuesInEpics(" (resolution = \"Won't Do\" or resolution = Duplicate) ") ORDER BY summary
serverIdebe8394f-6d75-344c-8d9c-717cb778a1eb

...