capabilities.work

Run a JQL Report and Drill Into a Result

A 3-step recipe with Jira. We can help you get access.

Recipe · 3 steps

Run a JQL Report and Drill Into a Result

with Jira
Works with AI assistants

Search Jira with JQL and drill into the first matching issue.

  1. Run the JQL query with a thin field projection suitable for rendering a list. Query validation is set to warn so a soft query issue surfaces as a warning message rather than failing the whole report.
  2. Read the first matched issue in full, expanding the changelog and rendered fields so the caller sees the issue's history alongside its current state.
  3. Retrieve the most recent comments on the drilled-into issue, newest first, to surface the current discussion alongside the report row.
What you'll need to have ready
  • jql: The JQL query to report on, e.g. project = PROJ AND status = "In Progress" ORDER BY updated DESC.
  • maxResults: The maximum number of issues to return in the report page.
For your developer

Arazzo workflow jira:jql-issue-report, 3 operations: getRestApi3Search → getRestApi3IssueByIssueIdOrKey → getRestApi3IssueByIssueIdOrKeyComment. Specs on APIs.io.