Click Add Data Source in Data Source

Fill all required information in Data Source

Click Test Connection to examine the connection between database and Jira

Click Save to save data source

In Table Grid section, choose Grids 

In Driving Table, click Add Driving Table button to add new driving table

Fill information for “Name”

In this example, user used

• Name = “Products”

In Configuration - Column, click Add new column to create new column

In Add Column, choose String in Column type

User fill information for Identifier and Title

Type “code“ as Identifier and type “Code” as Title

Click Add to save the information 

In Add Column, choose String in Column type

User fill information for Identifier and Title

Type “name“ as Identifier and type “Name” as Title

Click Add to save the information 

In Add Column, choose Number in Column type

User fill information for Identifier and Title

Type “price“ as Identifier and type “Price” as Title

Click Add to save the information 

In Configuration - Data Mirror,

Select the Data Source that you created in step #4

Fill the Database table name

Click Create table to create table in your database

Click Save to save the Driving Table Config

Click to add row in the Driving Table
Fill the product information into Driving Table

Click to save the Driving Table

In Grid Fields, click Add Grid button to add new grid

Fill information for “Name” and “Description” 

In this example, user used

• Name = “Shopping List”

• Description = “Shopping List use case”

In Configuration - Column, click Add new column to create new column

In Add Column, choose Single Select List in Column type

User fill information for Identifier and Title

Type “jproduct“ as Identifier and type “Product” as Title

In Option attributes, click to add option attribute

Type “price” as Key

In Dynamic options, chooseyour databasefor Data Source and type the SQL query:

SELECT name, price FROM products

Click Get data to get data from your database

In Mapping:

• for label, select “name”

• for price, select “price”

Click to save the dynamic options

Click Add to save the information 

In Configuration - Column, click Add new column to create new column

In Add Column, choose Formula in Column type

User fill information for Identifier and Title

Type “jprice“ as Identifier and type “Price” as Title

In Formula expression, type:

var result;
if($(jproduct).hasOwnProperty('optionObject')){
  result = $(jproduct).optionObject.price;
}else{
  result = $(jproduct).price;
}
return result;

Click Add to save the information 

In Configuration - Column, click Add new column to create new column

In Add Column, choose Integer in Column type

User fill information for Identifier and Title

Type “jquantity“ as Identifier and type “Quantity” as Title

Click Add to save the information 

In Configuration - Column, click Add new column to create new column

In Add Column, choose Formula in Column type

User fill information for Identifier and Title

Type “jtotal“ as Identifier and type “Total” as Title

In Formula expression, type:

return $(jprice)*$(jquantity)

Click Add to save the information 

Click Save to save the grid configuration 

Navigate to ScriptRunner, choose Fields

Click Create Script Field

Click Custom Script Field

In Field Name, type “Total amount”

In Template, select Text Field (multi-line)

In Script field, type the script

The script below helps to create a scripted custom field that calculates the sum of all numbers in the specified column of the TGNG grid

import com.atlassian.crowd.embedded.api.User;
import com.atlassian.jira.component.ComponentAccessor;
import com.atlassian.jira.issue.CustomFieldManager;
import com.atlassian.jira.issue.fields.CustomField;
import com.atlassian.jira.security.JiraAuthenticationContext;
import com.atlassian.plugin.PluginAccessor;
import com.atlassian.jira.user.ApplicationUser;
import org.apache.log4j.Logger;
// set up logger
Logger log=Logger.getLogger("com.idalko.scripts");
// get an issue
String tgngCustomFieldName = "TGNG Grid"; //Change the grid custom field name to relevant one
String columnIdToSum = "price"; //Change the column ID to the relevant one
// get TGNG custom field
CustomFieldManager customFieldManager = ComponentAccessor.getOSGiComponentInstanceOfType(CustomFieldManager.class);
CustomField tgngCustomField = customFieldManager.getCustomFieldObjectsByName(tgngCustomFieldName).get(0);
Long tgngCustomFieldId = tgngCustomField.getIdAsLong();
ApplicationUser applicationUser = ComponentAccessor.getJiraAuthenticationContext().getLoggedInUser();
// read grid data
PluginAccessor pluginAccessor = ComponentAccessor.getPluginAccessor();
Class apiServiceClass = pluginAccessor.getClassLoader().findClass("com.idalko.tgng.jira.server.api.GridService");
def gridFieldData = ComponentAccessor.getOSGiComponentInstanceOfType(apiServiceClass);
def callResult = null;
try {
    callResult = gridFieldData.readFieldData(issue.getId(), tgngCustomFieldId, applicationUser, null);
} catch (Exception e) {
    log.error(e.getMessage())
}
def gridRows = callResult.getRows();
Double sum = 0;
for (row in gridRows) {
    def column = row.getColumns().get(columnIdToSum);
    sum += column.toDouble()
}
return sum;

Info
Click on to view more example scripts

Click Add to save the Script Field

Step

Description

3

The system will automatically come back to the “Data Source” page

Use case stops. 

Step

Description

5

An “Errors” message appears 

Use case stops.

Step

Description

19

An “Errors” message appears 

Use case stops. 

Step

Description

26

The system shows a pop-up message: “Exit without saving?”

27

User click Yes button

Use case stops. 

Step

Description

32

The system will automatically come back to the “Script Fields” page

Use case stops.