Index
Brief review of JQL's
Key operators
Key functions
Translate business requirements into JQL
Types of reports
Jira gadgets
Agile reports
Dashboards
1. Brief review of JQL's
1.1 Key operators
1.2 Key functions
1.3 Translate business requirements into JQL
SmartValue is how Jira call variables
Business Requirement 1:
Find all unresolved issues assigned to a specific user that were created in the current month.
Business Requirement 2:
Identify all high-priority tasks across multiple projects that are past due and not yet in progress.
Business Requirement 3:
Retrieve a list of issues that are linked to resolved bugs in the 'Backend' component and are scheduled for the current release but have no fix version assigned.
Business Requirement 4:
Isolate all issues in the 'DevOps' project where the original time estimate was less than 8 hours but have exceeded their due date, excluding sub-tasks.
Answers
Business Requirement 1:
assignee = currentUser() AND resolution = Unresolved AND created >= startOfMonth()
Business Requirement 2:
priority = High AND dueDate < now() AND status not in ("In Progress", "Done")
Business Requirement 3:
issueFunction in linkedIssuesOf("status = Resolved AND component = Backend")
AND fixVersion = currentRelease() AND fixVersion is EMPTY
Business Requirement 4:
project = DevOps AND originalEstimate < 8h AND dueDate < now() AND type != Sub-task