Customizer Script to change any data column from decimal to integer value

In the Arsenale Dataplane Reports, if the values are displayed as decimals and if you want them to be displayed as integers, then this can be achieved using the Customizer Script.

 Instructions

  1. Below is an example of decimal values (.00) displayed by the Number field type custom field, “Verification fails“ in the chart and reports.

 

2. Dataplane Customizer Scripts have some undocumented APIs that we can use, like “getColumn()” and “setType()”.

3. By using the above APIs, we can change the data column to integer values, as seen in the below Customizer Script :

def FIELD_NAME = "Verification fails" customizeResult { // change this data column to integer values getColumn(FIELD_NAME).setType(DataColumnType.INTEGER) }