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}’

Browser not supported