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.
Contents
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
2. Navigate Table Grid
Select Grids in Table Grid on the left menu
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 Title → Click 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: