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 |
---|---|---|
Attribute xyz contains the value 1 when the checkbox is checked, else 0 | xyz = 1 | |
Attribute xyz contains a date type attribute. | xyz between '2013-02-12' and '2013-02-19' | |
Attribute xyz contains an integer | xyz > 18 | |
A list is stored using 2 attributes
| Assume your list contains 'Male' and 'Female'
| |
Attribute xyz contains a double number | xyz < 20.5 | |
Attribute xyz contains the label of the radio button ( | xyz = 'On' | |
Attribute xyz is an integer containing the sequence number | xyz between 100 and 200 | |
Attribute xyz is a string (max 255 chars) | xyz = 'hello there' | |
Attribute xyz is a text field (or similar depending on database) | xyz like '%hamlet%' | |
There are 4 attributes related to the tracking fields
| 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 |
| Examples
|
|
|
|