Reporting Jira Data Provider macro allows reading of Jira issue data from the specified Jira instance. The issues are searched by specified JQL query. The max number of issues may be specified, but cannot be higher than 1000 items. Data providers in Reporting return data in a form of an array of JSON objects - one JSON object per each report line. Then, in Reporting Table Item formulas these objects may be accessed via CurrentItem variable.

Reporting Jira Data Provider macro has the following parameters:

Parameter Description
[String] Source (default=''(Empty value))

An Application Link name (for Server/Datacenter) or URL (for Cloud) of the Jira instance to read data from.

Examples:

  • [Server/Datacenter] '' (Empty value) - Jira instance on Primary Link will be used.
  • [Server/Datacenter] 'My Company Jira' - Jira instance with App Link name 'My Company Jira' will be used.
  • [Cloud] 'https://{company_site}.atlassian.net' - Jira instance with URL 'https://{company_site}.atlassian.net' will be used.
[String] Query (default=''(Empty value))

A JQL query to be used to search for Jira issues. This parameter cannot be empty.

Examples:

  • 'Project = TST' - returns all issues of the TST project.
[String] Fields (default=''(Empty value))

A list of fields to return for each issue, use it to retrieve a subset of fields. This parameter accepts a comma-separated list. 

Examples:

  • 'summary,comment' - Returns only the summary and comments fields.
 [String] Filter (default=''(Empty value))

The formula, which filters out the values when it returns False. Ignored if empty.

Examples:

  • 'FIND("Report", CurrentItem.fields.summary) > 0' - Returns True for the issues with the summary, which contains a 'Report' word. So this formula helps to create a report with the issues, which have 'Report' word in its summary.
[Long] Max results (default=1000) The maximum amount of issues to be returned. This feature is convenient to create the lists of TOP Something, when the issues are sorted in JQL query and the amount is limited with this parameter.