Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 3 Next »

There are two Jira JQL Snapshot Macros:

  1. Jira jql snapshot:

    1. Retrieves the results of a Jira JQL query.

    2. The list of columns (fields) is configurable by the Macro

  2. Jira jql traceability snapshot:

    1. Retrieves a two level traceability report: for example the list of requirements, and the specifications which are implemented by each requirement.

    2. Each of the levels is defined by a JQL query. The lower level query is dependent on the first level.

    3. The list of columns (fields) is configurable by the Macro.

JQL is 'Jira Query Language'. This is the native query language for Jira, and these macros use it directly when retrieving data from Jira.

See here the complete JQL reference: https://confluence.atlassian.com/jirasoftwareserver/advanced-searching-939938733.html

Its a good idea to check that the JQL is correct in Jira, before using it in the Jira jql snapshot Macros- this will help ensure that the macro actually displays the data you intend it to display.

Key Features

  1. Any legitimate JQL clause can be used to retrieve data from Jira.

  2. List of columns is configurable.

  3. Retrieving fresh data from Jira into Confluence is done from the page VIEW mode, by clicking the refresh button

  4. Each time fresh data is imported, it generates a new Confluence Page version. This can be seen in the Page History view. 

  5. A DIFF tool allows you to compare between the current Jira data and any of the previous snapshots. 

  6. A single Confluence page may include multiple instance of the snapshot macros, each retrieving another set of data.

Known Limitations

  1. The snapshot macros cannot retrieve files (ie- images) from Jira. So, if a 'description' field contain a screenshot image, this image will not be included in the Confluence data. Note: You might still see this image ij Confluence if it is cached in your browser, but this is just a coincidence. The image will no longer display if you clear you browser cache.

  2. Jira fields may have many different formats, and some Apps may even have their own custom field types with their special formats. This may lead to situations that some fields do not display correctly. Please contact RadBee if you run into this situation: and we'll try to adjust.

Using The Jira JQL Snapshot Macro

We assume you have a Confluence page, on which you want to add a table of Jira data. 

  1. EDIT the page and navigate to the location where you want the table to be.

  2. Enter this Macro on the page: "Jira jql snapshot"

  3. These are the parameters:

    1. JQL: This is a legals JQL clause that retrieves the data you want to have in the table, for example: filter="PPD Breast Risks"

    2. Fields: A semicolon separated list of fields. 

      1. For example: issue type;key;Components;Summary;Fix versions;Hazard;Harm;Probability;Impact;Risk level;Protective measures;Information for safety;Residual Probability;Residual Impact;Residual risk level;Residual risk impact;Residual risk acceptability

    3. Macro id: put here any unique string (unique in the scope of this page). This parameter is only needed if you have more then a single Snapshot macro on the same Confluence page.

  4. After configuring the parameters you can save the page.

  5. Initially, no data will be presented.

    1. Note: it is possible that you will be required to "authenticate to Jira": this is required to allow you to retrieve fresh data from Confluence.

  6. Click the "CREATE CONTROLLED SNAPSHOT" button to initiate the retrieval of fresh data from Jira.

Using The Jira JQL Traceability Snapshot Macro

Using the "Jira JQL traceability snapshot" macro is identical to using the "Jira jql snapshot", except that the list of configuration parameters is longer and caters to the "two levels traceability".

Here is the list of parameters

  1. Level 1 Title

  2. Level 1 JQL: This is any legal JQL clause that retrieves the data you want to have in the table,

    1. for example: project = PPD AND issuetype in ("Functional Requirement", "Non Functional Requirement") AND component = "Paige Breast Classification"

  3. Level 1 Fields: A semicolon separated list of fields. 

    1. For example: Key;Summary;Description

  4. Level 2 Title

  5.  Level 2 JQL: This is any legal JQL clause that retrieves the data you want to have in the table. In this JQL clause you can include reference to any of the columns of the first level, by refereing to it with a $ sign

    1. For example: issuetype = Test AND issue in linkedissues($Key, "is tested by")

  6. Level 2 Fields: A semicolon separated list of fields. 

    1. For example: Key;Summary;TestRunStatus - Current Version

  7. Macro Id: put here any unique string (unique in the scope of this page). This parameter is only needed if you have more then a single Snapshot macro on the same Confluence page.

  • No labels