Driving Tables

Create tables with data that is not connected to any issues. Use the driving table as a data source for your grid.

This article describes how you can create stand-alone tables in Table Grid Next Generation.

Create tables with data that is not connected to any issues. Use the driving table as a data source for your grid. 

The Driving Table is a stand-alone table that is not connected to any issue. You can use it as a data source. 

The driving table allows you to manage the data without access to the database. You can create a table, add data, then export it to the external database and re-use it elsewhere.

Driving Table Configuration

To create a driving table, follow the steps below:

 1. Navigate to add-ons in your Jira administration 

In the Jira Administration pop-up, click Manage app

image-20231227-080345.png

2. Navigate Table Grid

Select Grids in Table Grid on the left menu

image-20231227-041528.png

 

3. Open Driving Tables

Select Driving Tables tab on the top

4. Add driving table

User click Add Driving Table to add new driving table.

5. Fill information for Driving Tables

In Driving Tables section, user type the Name and Description of the Driving Tables

In this example, writer used “Laptop_sale_management_1” for Name and Description

6. Configure table columns

User can click Add new column to add new column

The driving table columns are configured in the same way as grid columns. 

First, user need to choose for Column Type → click Add to save the information

Secondly, user must type Identifier and TitleClick Add button to save the information

 

In this example, writer created 4 new columns as described below

  • First driving table column with String for Column Type. Type “pcategory” for Identifier and “Category” for Title. → Click Add button to save the information

  • Second driving table column with String for Column Type. Type “pmanufacturer” for Identifier and “Manufacturer” for Title → Click Add button to save the information

  • Third driving table column with String for Column Type. Type “pmodel” for Identifier and “Model” for Title → Click Add button to save the information.

  • Fourth driving table column with Number for Column Type. Type “pprice” for Identifier and “Price” for Title → Click Add button to save the information.

Check out how to configure сolumns for more details.

7. Click Data Mirror

Click Data Mirror, then choose Data Source and type for Database table name

In this example, the selected Data Source is “Product” and the Database table name is “laptop_sale_management_1”. After user fill information, the Mapping section will appear to validate the column information.

User click Create table and Validate button, there are pop-ups show when the table is created successfully

*Please note that the Database table name can only contains alphanumeric characters and underscores

User click the button to add data in the driving table and click button to save the configuration.

User can download and use this config:

8. Save the driving table configuration

Click Save to save the driving table configuration

Navigate to MySQL Workbench

When user open MySQL Workbench, click on the selected table and then the full table with displayed as below

In the example, the table Laptop_sale_management_1 is found on MySQL Workbench with the full dataset.

If user want to make any changes with the data, they can navigate to Driving Tables → select a table → double click the box to edit → Click button to save any changes.

 

With the following steps, user can utilize the driving table as external datasource for Jira fields.

To understand more about the application of driving table on Jira project, user can read more about these 2 use cases: