We are at Atlassian Summit - which will affect our response times. Meet us there (if you happen to be in San Jose)

Skip to end of metadata
Go to start of metadata

The table grid editor documentation has moved to Table Grid Editor for Jira Server Documentation.


Overview Table Grid Editor Table Grid Reader Multi Level Cascade Still working on multiple issue trackers ? Synchronize any data flexibly with exalate


Adds an additonal row with a summary of the column. This summary can be either 'sum', 'avg', 'count', 'min', 'max' or just a label such as 'total:'

Class

Column

Property

col.xyz.summary

Formal specification

col.xyz.summary ::= sum |avg |count |min |max | label
label ::= string - the label allows to detail out what the calculated value represents

Required

no

Default

No (unless it is a label)

Version

1.0

Comment

A summary on a column of type string has no effect, unless it is a label

Example

gd.columns=sandwich,price,number 
col.sandwich=Sandwich 
col.sandwich.type=string 
col.sandwich.editable=false 
col.sandwich.summary=Total: 
col.number=Count 
col.number.type=number 
col.number.summary=sum 

Reference

col.xyz.type = number
col.xyz.type = integer

2 Comments

  1. can I know how to do summary of check or list type?

    here is how the data saved in DB: https://drive.google.com/open?id=0B-gcM-UXBsXcX3RqNXZoRjNjcG8

    and here is the Grid Display in Jira: https://drive.google.com/open?id=0B-gcM-UXBsXcTnYzVkdmTmJVb28


    Below are my Grid setting for R and C field. Please advise, thank you, 

    col.R=Return
    col.R.type=checkbox
    #col.R.checked=0
    #col.R.unchecked=1
    col.R.summary=Total

    col.C=Status
    col.C.type=list
    col.C.width=auto
    col.C.list.size=3
    col.C.name1=Assign
    col.C.value1=1
    col.C.name2=Return
    col.C.value2=0
    col.C.name3=Lost/ none return
    col.C.value3=-1
    col.C.defaultValue=1
    col.C.summary=sum

    1. Did you consider our table grid editor (tge)
      API Java API: Groovy script examples


      This allows to massage any data in the grid
      Also - there are examples in the FAQ