Configuration Codes

JQL Examples for Portfolio Scope

All Active Epics Across Projects

issuetype = Epic AND status != Done ORDER BY priority DESC

High-Priority Issues Due This Quarter

priority in (Highest, High) AND due >= startOfQuarter() AND due <= endOfQuarter() ORDER BY due ASC

All Stories Without a Due Date

issuetype = Story AND due is EMPTY AND status != Done

Sprint Issues for a Specific Team (by Assignee Group)

sprint in openSprints() AND assignee in membersOf("engineering-team") ORDER BY priority DESC

Overdue Issues

due < now() AND status not in (Done, Closed, Resolved) ORDER BY due ASC

Issues Updated in the Last 7 Days

updated >= -7d ORDER BY updated DESC

Multi-Project Portfolio with Issue Type Filter

project in (PROJ1, PROJ2, PROJ3) AND issuetype in (Epic, Story) AND status != Done

---

Report Filter Combinations

Who Logged the Most Time Last Week?

• Group by: Assignee
• Date range: Last 7 days
• View mode: Weeks
• No project filter (or filter to specific project)

Where Did Our Team Spend Time Last Month by Category?

• Group by: Time Category → Assignee
• Date range: Current month
• View mode: Months
• Filter: Project = [your project]

Estimated vs. Actual by Issue Type

• Group by: Issue Type → Issue
• Date range: [Sprint dates]
• View mode: Weeks
• Columns: Include "Original Estimate" and "Logged Time"

---

Scoring Template Formula Reference