Text Mode in Reporting: Eliminating parts of the data that appears

[CT64839242323]

Hello,

I am using text mode to pull every user and their job role in a project into a report. I used the text Below and it works. Is there a way to remove the fact that requester was pulled into the report or hide it. Thank you!

displayname=Project Users
listdelimiter=<hr>
listmethod=nested(projectUsers).lists
type=iterate
valueexpression=CONCAT({user}.{name}," - ",{user}.{role}.{name})
valueformat=HTML

[TealeMc4]

I'm not sure if you're saying that the user's role is "Requester" or if the person that requested the project is appearing in the results. If it's that latter, can you just remove the person from the People tab? 

[Sven-iX]

projectUsers includes everyone who is, or was, assigned to a task, issue or as the owner, even if they're no longer assigned. 

So iterating over that list may not be what you want. 

The fact you get the "requestor" sounds like that person either converted the issue to a project, or Fusion - regardless, s/he appears in the People tab of the project. 

You could filter what you display by role e.g.

• IFIN({user}.{roleID}, IDofRole1, IDofRole2, CONCAT({user}.{name}," - ",{user}.{role}.{name}), "")

However - note that if you DON'T display a list item you get 2 <hr>s - there's no way to filter the collection you iterate over.