...
Brief review of JQL's
Key operators
Key formulasMost common formulas in examfunctions
Translate business requirements into JQL
Types of reports
Most used Jira gadgets
Most used Agile reports
Dashboards
1. Brief review of JQL's
1.1 Key operators
Each change in Jira trigger an event in the system
| Drawio | ||||||
|---|---|---|---|---|---|---|
|
...
|
...
|
...
|
...
|
...
|
...
|
...
|
1.2
...
Key functions
| Drawio | ||||||
|---|---|---|---|---|---|---|
|
...
|
...
|
...
|
...
|
...
|
...
|
...
|
...
|
1.3
...
Translate business requirements into JQL
SmartValue is how Jira call variables
...
1.4 What are REST API and HTTP Requests?
...
2. Automation
2.1 Bulk change
The process of making mass updates to multiple issues at once, such as changing the assignee, updating fields, deleting issues, or transitioning issue statuses
2.2 Workflow automation
Enables users to create rules that automatically trigger actions within the workflow
2.3 Automation with Apps
Enhancing Jira's built-in automation capabilities by integrating third-party apps that offer additional automated actions, triggers, etc…, e.g ScriptRunner
2.4 Jira automation
Feature within Jira that allows users to configure automatic actions in response to specific triggers
2.5 Create a Jira automation
Create a rule based on business requirements
2.6 Jira Automation template
Pre-built rule or set of rules that can be used as a starting point for common automation tasks, providing an easy way to quickly implement automation
2.7 Troubleshoot Jira AutomationBusiness 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
| Child pages (Children Display) |
|---|
...