Confluence User •

14 Sep, 2021 •

confluenceUser •

•

confluenceUser •

Use Loadbinder to load the data and use "FIND_IN_SET()" mysql function and display the data of all selected users.
you might want to replace ';' with ',' using "REPLACE" mysql function.

You might be able to use this query below. my field "t.c_dockTeam" contained the multiselected user column

SELECT d.id, concat(d.firstName, ' ', ifnull(d.lastName, ''))
FROM dir_user d
LEFT JOIN app_fd_teamformate t ON find_in_set(d.id, REPLACE(t.c_dockTeam, ";", ",")) > 0

1

CSV | Excel | XML | PDF