Column to attribute mapping



The data in grid columns are persisted in a table which can be queried by the grid search JQL function.

This page details out how a column name 'xyz' is mapped to an attribute in the database table.

Note that the attribute used in the database table can be modified using the col.xyz.name property.



Column Type

Attribute names

Example to use in the function

Column Type

Attribute names

Example to use in the function

col.xyz.type = checkbox

Attribute xyz contains the value 1 when the checkbox is checked, else 0

xyz = 1

col.xyz.type = date

Attribute xyz contains a date type attribute.
Use specific database notation to query for date ranges

xyz between '2013-02-12' and '2013-02-19'

col.xyz.type = integer

Attribute xyz contains an integer

xyz > 18

col.xyz.type = list

A list is stored using 2 attributes

  • xyz contains the value of the list

  • xyz_name contains the corresponding label

Assume your list contains 'Male' and 'Female'
with values 'M' and 'F'

  • xyz = 'M'

  • xyz_name = 'Male'

 

col.xyz.type = number

Attribute xyz contains a double number

xyz < 20.5

col.xyz.type = radio

Attribute xyz contains the label of the radio button (

xyz = 'On'

col.xyz.type = sequence

Attribute xyz is an integer containing the sequence number

xyz between 100 and 200

col.xyz.type = string

Attribute xyz is a string (max 255 chars)

xyz = 'hello there'

col.xyz.type = textarea

Attribute xyz is a text field (or similar depending on database)

xyz like '%hamlet%'

Tracking fields

There are 4 attributes related to the tracking fields

  • DT_CRE - a date field

  • JIRA_USER_CRE - a string

  • DT_UPD - a date field

  • JIRA_USER_UPD - a string

For instance DT_CRE > '2013-02-01' to get all the issues where a row has been created after Feb 1, 2013

Specific management fields

  • modified is an attribute indicating if the row has been modified by the user.

  • issueid is the id of the containing issue

  • id is the id of the row in the table

Examples

  • modified = 1

  • modified = 0

  • issueid = 10000