---
title: "Configure Jira work items in Advanced Table Viewer macro"
canonical: "https://support.appfire.com/space/TBL/3510927447/Configure%20Jira%20work%20items%20in%20Advanced%20Table%20Viewer%20macro"
format: markdown
---
> Macro (aura-html)

---

This page details how to configure the Advanced Table Viewer macro to import Jira work items.

## Configure the Jira work items

> Macro (refined-tabs)
> 
> > Macro (refined-tab)
> 
> - Insert the macro in a Confluence page using the macro browser or the macro shortcut (/).
> - On the initial setup screen, click **Connect Data Source**.
> - The *Select* *data source* dialog opens.
> - To configure the Jira data source, select **Jira work items** from the *Select data connector *dropdown. By default, the CSV data connector is selected.
> 
> > 📝 - If the Jira site is not connected, the macro displays a message to connect to the Jira site.
> 
> - Once you choose Jira work items, the dialog displays the following fields and details.
>   - **Jira site**: Displays the Jira site the Advanced Tables for Confluence app is connected to. You can import Jira work items from this site.
>   - **View Jira projects**: This navigates you to the Jira site projects page, displaying the projects list.
>   - **JQL query**: Displays a default Jira query to import data.
>     - To import the required Jira work items, enter a JQL query.
>       - As you enter the query, the JQL query editor displays a real-time syntax autocomplete dropdown to quickly complete your query.
>       - To validate the query and import Jira work items, click **Search **( ).
>     - The macro validates the **JQL query**. If valid, it returns the count of work items found; if invalid, it displays an error message.
> 
> > 📝 - To expand the JQL query editor, click Expand editor ( ).
> > 📝 - If you need help with JQL syntax, click [Syntax help](https://support.atlassian.com/jira-service-management-cloud/docs/use-advanced-search-with-jira-query-language-jql/) ( ).
> 
> - **Columns**: In the Columns field, you can specify the list of Jira fields to be imported. By default, a few Jira fields such as Issue key, Summary, Status, Assignee, Priority, and Updated are preselected. You can remove fields, select more fields, and reorder them. For further configuration, proceed to the **Select and order columns** section on this page.
> 
> 
> > Macro (refined-tab)
> 
> The** Columns** field displays a few default Jira fields as column names to import. You can remove, select, and reorder the column names as needed.
> 
> - Clear all selected columns
>   - To remove all column selections at once, click **clear all** (:cross_circle: ). After clearing, click the field and re-select column names in the required order.
> - Remove a specific column
>   - Next to the column name, click **clear** (:cross_circle:) to remove it from the selection.
> - Select columns
>   - Click the** Columns** field and choose the column names from the list.
> 
> > ℹ️ The order in which you select the column names determines the column order displayed in the Confluence table.
> 
> Once you have selected the required columns, proceed to the **Save and publish **section on this page.
> 
> > Macro (refined-tab)
> 
> - In the *Select data source* dialog, click **Save**.
> - The macro opens in setup mode, displaying the table with the selected column names and Jira data.
> - In setup mode, you can configure various available features, such as column filtering, grouping, row styling, search, row numbering, sorting, download, and sum-up. Refer to [Set up the Advanced Table Viewer macro features](https://appfire.atlassian.net/wiki/spaces/TBL/pages/1765147138).
> - To apply the configurations, click **Save**.
> - The configured table appears in the Confluence page edit mode.
> - **Publish** the page to view the table in the Confluence page view mode.
> - Your Jira work items are now ready to view and analyze directly within Confluence.
> 
> > 📝 - To refresh the imported Jira work items for any changes from the Jira instance, click **Refresh** ( ).
> > 📝 - You can refresh the Jira work items in setup mode, page edit mode, and page view mode.