...
Brief review of JQL's
Key operators
Key functions
Translate business requirements into JQL
Most common formulas in exam
Types of reports
Jira gadgets
Agile reports
Dashboards
1. Brief review of JQL's
1.1 Key operators
https://support.atlassian.com/jira-software-cloud/docs/jql-operators/
| Drawio | |||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
...
|
...
|
...
|
...
|
1.2 Key functions
Post-functions, conditions, properties, validators
| Drawio | ||||||
|---|---|---|---|---|---|---|
|
...
|
...
|
...
|
...
|
...
|
...
|
...
|
...
|
1.3 Translate business requirements into JQL
SmartValue is how Jira call variables
...
1.4 Most common formulas in exam
...
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:
| Code Block |
|---|
assignee = currentUser() AND resolution = Unresolved AND created >= startOfMonth() |
Business Requirement 2:
| Code Block |
|---|
priority = High AND dueDate < now() AND status not in ("In Progress", "Done") |
Business Requirement 3:
| Code Block |
|---|
issueFunction in linkedIssuesOf("status = Resolved AND component = Backend")
AND fixVersion = currentRelease() AND fixVersion is EMPTY |
Business Requirement 4:
| Code Block |
|---|
project = DevOps AND originalEstimate < 8h AND dueDate < now() AND type != Sub-task |
...
2. Type of reports in Jira
2.1 Jira gadgets
...
2.2 Agile reports
...
3. Jira dashboards
...
3. Additional material
...