JQL Matrix


Create a JQL Matrix

You can use our Extended JQL syntax for the queries of your JQL matrices.
This additional tool allows you to compare custom field or system field values in issues with the current issue’s values.

As a result, you can build much more sophisticated and dynamic Issue Matrices displaying a list of issues tailored to the current issue.

To create JQL Matrices:

  1. On your Jira Cloud site, navigate to your Project settings or Project settings > Apps for team-managed projects.

  2. On the left menu, choose Issue Matrix Configuration.

  3. On the Issue Matrices page, click the Add Matrix button.

  4. From the menu, choose the JQL Matrix type.

  5. On the Add Matrix page, you can set configuration options to build the matrix panel you want to see in your issue.

  6. Context > Linked Projects: Choose the projects where you want the matrix panel to appear. By default, the Issue Matrix configuration is linked to the current project only. If you add more than one project in the Projects to link field, you will create a multi-project configuration. The Issue Matrix configuration and panel will appear in all linked projects.

    With multi-project issue matrices, changes to the Issue Matrix configuration in one of the projects will affect the rest of the projects.

  7. Context > Issue Types: After specifying the linked projects, choose issue types for each of them in the Context > Issue Types section.
    Keep in mind, that the different projects might be associated with different issue types. For that reason, for each project, you need to choose the issue types where you would like to show the Issue Matrix panel.

  8. Type: In this section, enter a JQL query that returns issues from your Jira. Include the sorting of the data in the query.
    Build a query that uses our extended JQL syntax for a more refined search of issues.

  9. Data > Columns: Configure the width and headers of the columns that the Issue Matrix will display. The columns correspond to custom fields from your Jira Cloud instance. The panel will visualize the values of the custom fields for each issue.

  10. Data > Results: Select the maximum number of issues to be displayed in the Issue Matrix panel and set the number of results per page.

  11. Data > Categories (optional): Use JQL to set color categories for organizing your issues. Colored squares will appear on the left of issues that belong to a specific category. Note that each issue can only have one category.

  12. Sort By: There isn't a Sort by configuration option for the JQL Matrices. If required, you can include the sorting in the JQL query in the Issue Matrix configuration.

  13. Save the configuration.

The new JQL Matrix will appear at the bottom of the list on the Issue Matrices page.

Sorting via ORDER clauses

The default sort order in JQL matrices can be specified via ORDER clauses in the JQL entry, as the Sort By option isn’t available for these types of Issue Matrices.

Â