ACP-620 Day 5: Reporting

Owned by Frank Lapa
Last updated: Nov 08, 2023Version comment
1 min read

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

 

 

2. Type of reports in Jira

2.1 Jira gadgets

2.2 Agile reports

3. Jira dashboards

 

3. Additional material

 

 

 

Â