Home > Forum > Tips&Tricks > Showing multiple "assigned to" in report

Showing multiple "assigned to" in report

3

15.03.2023

10:19

Hi,

I'm seeking a hint, how to show in the table report that an item is assigned to more than one person. Has anybody an idea?

When a task is assigned to more than one, it is visible in the info bar in the item form, but in the tabled report (e.g. "all open instances") it shows only one name.

Is it possible to show the result of a business rule in a report?

Kind regards,
Klaus

PS: we are using V2021

15.03.2023

11:42

Hi Klaus, I'm replying just to be in the loop if someone responds. :)

Solution (0)

Helpful (1)

Wrong answer (0)

Wojciech Mleczko

15.03.2023

15:51

WEBCON

Wojciech Mleczko

This behavior is due to performance reasons.

If you want, you can use calculated column using query like:

(select STUFF((
SELECT '; ' +(wft_username)
FROM dbo.wfelementtasks
WHERE wft_wfdid = wfelems.wfd_id
AND wft_wfhid IS NULL
AND wft_isfinished = 0
AND wft_assigntypeid IN ( 1, 2 )
AND wft_orgid IS NULL
FOR XML PATH('')
), 1, 1, '')
)

Solution (4)

Helpful (0)

Wrong answer (0)