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

Using list values in formulas