This article explains how to do issue filtering in the JQL table macro using the app Advanced Tables for Confluence.
Instructions
- Log into your Confluence instance as an administrator.
- Create an application link with a Jira instance and make sure it is working.
Refer to this page on how to do Linking to Another Application. - Create a new page or click
to edit an existing page. - Insert the Advanced Table - JQL Table macro on the page.
- Edit the JQL Table macro, navigate to JQL settings > Data source > Jira application links and select the link that you have created in step #2.
Also, enter the JQL for Jira Advanced search to fetch your issues from the project as shown:
- Navigate to Table settings > Advanced settings > Display data filter and Enable as shown:
- Click on Save settings and Publish the page.
- Once you run the JQL, it will be showing the issues as shown:
- Select filter on a column of the table, it filters the column data as shown:
We recommend testing this in a non-production environment before implementing it in production.