Table Grid Next Generation

Note on Exporting Table Grid Data:
When using the SQL Connector for Jira to export data from the Table Grid Next Generation app, you may notice that the export process takes longer than expected. This is due to the method by which the data is retrieved: the connector must process each issue that fits the criteria specified in your filter.
To enhance the speed and efficiency of your data exports, we highly recommend using precise filtering. Employing a detailed JQL that targets exact issue keys for the data you need will significantly reduce the amount of data processed and, consequently, the time required for exports.

 

Table Grid Next Generation Overview

 

Table Grid Next Generation - is a smart solution to track your tasks, orders, and invoices in a structured manner and pull data from various sources.

Track milestones, releases, quote line items, employee history, products & more in easy-to-digest tabular form.

Table Grid NG fields are located in a separate tab.

table_grid_ng_tables.gif

How to Add Table Grid Next Generation Token

 

Table Grid Next Generation Token is required to view and export data.

 

  1. Being signed in to your Jira Cloud instance, select Apps, and then select Table Grid Next Generation.

apps_manage_your_apps (1).gif

 

  1. Select API Tokens (Under the TABLE GRID section).

table_grid_api_tokens.gif

 

  1. Select Add API Token.

table_grid_add_api_token.gif

 

  1. In the API Token label field, enter the name of your API token, and then select Create.

Select a label that is short, memorable, and easy for you to remember.

table_grid_ng_create_api_token.gif

 

  1. Select Copy to clipboard.

Before closing the window, make sure you copy your new API token. You won’t be able to see this token again.

table_grid_api_token_copy_to_clipboard.gif
  1. Select Apps, and then select SQL Connector for Jira.

table_grid_ng_apps_sql_connector_for_jira.gif

 

  1. On the left-side menu, select API Integrations, and then select Table Grid NG.

api-integrations-table-grid.gif

 

  1. In the Token* field, paste your newly-created API token, and then select Validate & Save.

table-grid-validate-and-save.gif

 

Starting now, all users with granted permissions to work with data source and who added the token can select Table Grid NG tables and fields for export.

table_grid_ng_tables_for_export.gif

Table Grid Next Generation Tables Filtering

 

SQL Connector for Jira Cloud offers filter by Grids.

  • If you need to export data from a certain grid, you can select it from the drop-down list in the filter.

table_grid_ng_filtering.gif

 

  • If you need to export data from grids in a certain project, you can select it by using the Basic filter.

The filters Created date and Updated date are related to the issue created and updated dates.

 

table_grid_ng_basic_and_project.gif