In This article describes column values placeholders and how they can be used in the Table Grid Next Generation, you can create dependencies between the grid columns. .
Excerpt | ||
---|---|---|
| ||
Create dependent columns like cascading select lists in a grid using column values placeholders. | ||
Style |
Column values placeholders allow you to create dependencies between the grid columns.
For example, a cascading list that filters column data based on the value from another column.
...
'{column:<grid_column_identifier>:<option_attribute_key>}'
column — grid - Grid column element that helps to distinguish the column placeholder from the Jira value placeholder.placeholder
<grid_column_identifier> — - the identifier of the column which value you want to use in order to filter data.
<option_attribute_key>
— The key of the option attribute.
...
In the examples below, we will show all formulas with the label
option attribute, that is used by default in Single Select List and Multi Select List columns. You can replace label
with other option attributes.
...
For example, get a value from the column where the identifier is is user.
Code Block |
---|
{column:user:label} |
SQL query with the column value placeholder to get a summary of all issues assigned to the user, selected in the user column
Code Block |
---|
select summary from jiraissue where assignee = ‘{column:user:label}’ |
Note |
---|
Use Be sure to use quotes as in on the example below to get the correct value. |
...
Panel | ||||
---|---|---|---|---|
| ||||
Use case You have a grid with two select list columns and you want to display options in the second select list depending on the value in the first column. You can add dynamic options to your select list and query data from the custom field using Jira values. Pre-requisites
Solution Filter options in a User column with the help of column value placeholder
|
Panel | ||||||
---|---|---|---|---|---|---|
| ||||||
Use case Filter tasks assigned to a specific user based on the username selected in another grid column. You have a grid with 3 select lists columns and you want to display options in the User select list depending on the user group selected in the first column. Then based on the user selected in User column populate the list of tasks assigned to this user. Pre-requisites
Solution Display tasks assigned to a specific user in a dynamic multi-select list based on the user group. First, get a list of user groups from the Jira database using dynamic options for the User Group select list
Second filter Jira users in Users column, based on the value of the User Group column
Then populate the To Do list with Jira issues' keys using a dynamic multi-select list based on the User value selected in the previous column.
|
Note |
---|
Cascading list columns use dynamic options that are dependent on each other. In case you need to avoid the dependency combine status and dynamic options. |
...