I need a report like this. I can get it to work with the following text mode:
displayname=Workplace Services Lead
listdelimiter=<p>
listmethod=nested(projectUsers).lists
textmode=true
type=iterate
valueexpression=IF(CONTAINS("Workplace Services Lead",{user}.{role}.{name}),{user}.{name})
valueformat=HTML
However it returns all people that have the job role Workplace Services Lead and I need it to display only if they are assigned to a task as the primary assignment.
Any help would be appreciated.
Thank you!
-Mollie