Jira Snippet Library: JQL - For Dashboards

[#1]

Queries For Dashboards

As a project manager, owner, or team lead, it’s often your job to ensure work is measurable in Jira. But without important data, like assignees, estimates, and due dates, reports are often blank or useless. Instead, I create dashboards to alert me to undesired data conditions. E.g., Work has started but the assignee is missing. (You could also use filter subscriptions or automation flows to report these problems.)

If all is well, the dashboard gadgets should be empty and show no items. (Pictured) If items are present, someone needs to follow up and get those fields filled!

No overdue items to follow up on

Here are the queries I use most often to catch missing data. You may need to customize these to fit how your organization works.

Unassigned work in progress

• project = KEY and assignee is EMPTY and status != "To Do"

Items missing story points

• project = KEY and "Story points" is EMPTY and status != "To Do"

Items missing time estimates

• project = KEY and originalEstimate is EMPTY and status != "To Do"

Items missing due dates

• project = KEY and due is EMPTY and status != "To Do"

Items missing fix versions

• project = KEY and fixVersion is EMPTY and status != "To Do"

Items missing worklogs

• project = KEY and timeSpent is EMPTY and status != "To Do"

Items not updated in two weeks

• project = KEY and updated <= -2w and status != Done

Overdue items

• project = KEY and resolution is EMPTY AND due < now()

Items on hold

• project = KEY and status = “On Hold”

---

Back to intro or article list