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