This article describes column values placeholders and how they can be used in the Table Grid Next Generation.
| Excerpt | ||
|---|---|---|
| ||
Create dependent columns like cascading select lists in a grid using column values placeholders. |
...
Column values placeholders allow you to create cascading lists in a grid. To create a cascading list you need to filter data in a simple select list dependencies between the grid columns.
For example, a cascading list that filters column data based on the value from another column.
...
To get the value from another grid column use the following placeholder syntax
'{column:<grid_column_identifier>}'
column - Grid column element that helps to distinguish the column placeholder from the Jira value placeholder
...
| Code Block |
|---|
select summary from jiraissue where assignee = ‘{column:user}’ |
| Note |
|---|
Be sure to use quotes as on the example below to get the correct value. |
Examples
The most common use case for the column values placeholder is creating cascading lists.
| 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
|
...
| 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. |
See also
Using grid to create invoices and manage quotes