Driving Tables

Are you using lists of values in the Table Grid Editor for Jira Server and you want a simple way to manage its lists, check out the Driving Table editor.

The driving table editor allows you to create and manage these lists in the same way as you create and manage table grids.

Use case - the product list 

In this example JIRA and the table grid editor are used to manage quotes.  

JIRA is used to track the status of a quote, and the Table Grid Editor is used to list all the line items in the quote.

One of the columns contains a list of available products.  This dynamic list is based on a driving table,  maintained in the JIRA table grid editor admin.

Configure the products columns in the Quote Line items table

To ensure that the line items refer existing products, products are retrieved from a database table 'products'. Notice, that price is taken from the same lookup table from another column.

gd.tablename=products gd.columns=item,sku,quant,price,total gd.ds=gridds col.item=Item col.item.type=string # # Product is a drop down (select) list # The query will retrieve, next to the name and the code, also the price # col.sku=Product col.sku.type = list col.sku.query = select iname, icode, iprice from products_d2 order by iname col.sku.query.ds = gridds col.sku.autocomplete = true # # The user can set the number items to purchase # col.quant=Quant col.quant.type=number # # The price is set based on the selection of the product using a formula # \{sku.iprice} is the corresponding price retrieved with the query # col.price=Unit Price col.price.type=number col.price.formula={sku.iprice} # # The total is calculated from the price * the quantity (using a formula) # col.total=Total col.total.type=number col.total.formatnumber=##.00 EUR col.total.formula={quant} * {price}

Configure the driving table - Products

Using a driving table you can actually edit the list of values presented to the user.

In the JIRA administration navigate to Add-ons -  on the left menu, under Table Grid Editor administration choose Driving Table Admin 

Now you can see the Driving Table admin page where you can manage driving tables:

  • add a new table 

  • modify the existing table

Use the same approach  to configure the driving table as you used to configure the table grid

# # Setup a grid to manage products # gd.columns = icode, iname, iprice gd.tablename = products gd.visiblerows=15 # # Connect to the database to store the product list # gd.ds = igridtest # # Define the columns # col.icode = Code col.icode.width = 100 col.icode.type = string col.iname= Name col.iname.width = 400 col.iname.type = string col.iprice= Price col.iprice.width = 100 col.iprice.type = number

Note that a number of grid properties don't apply.  More details are available on the Driving Tables - configuration page.

Driving Table access 

By default only administrators can access the Driving Table Admin.

You can also grant users permissions to access the Driving Table. In order to do that, create an igrid-admin user group and add users to the group.

A user will get a separate menu tab with Driving Tables access.

The user has access to the list of existing driving tables, can create a new driving table, add/edit data in the existing one. 

The access is limited and it's not possible to remove or change existing configurations.

More advanced configurations

More advanced configurations are possible such that you can model any information.  For instance if you want to create a pricing table where prices depend on the product and the tier:

Related information