Page Comparison

...

The most common use case for the column values placeholder is creating cascading lists. 

...

Simple cascading list

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

• Single select list column User Group with dynamic options populated from the Jira database 

• Single select list column User with dynamic options populated from the Jira database and filtered by the value selected in the User Group column.

Solution

Filter options in a User column with the help of column value placeholder

• SQL query to get the list of user groups from the Jira data source

  Code Block
  select group_name from cwd_group

• SQL query to get the list of users in a certain group. 

  Code Block
  select child_name from cwd_membership where parent_name='{column:group}'

...

Filter To Do tasks assigned to a specific user from the selected user group

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

• Single select list column User Group with dynamic options populated from the Jira database 

• Single select list column User with dynamic options populated from the Jira database and filtered by the value selected in the User Group column.

• Multi-select column To Do with dynamic options populated from the Jira database and filtered by the value selected in the User column.

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 

select parent_name from cwd_membership

Second filter Jira users in Users column, based on the value of the User Group column

select child_name from cwd_membership where parent_name='{column:group}'

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. 

select concat(p.pkey, ‘-’, ji.issuenum) as key from jiraissue ji inner join project p on ji.project = p.id where ji.assignee=‘{column:user}’

...