Brief review of JQL's
Key operators
Key functions
Translate business requirements into JQL
Types of reports
Jira gadgets
Agile reports
Dashboards
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.
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 |