Expand my Community achievements bar.

Join us LIVE in San Francisco on November 14th for Experience Makers The Skill Exchange. Don't miss out on this free learning event!

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

Avatar

Level 2

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

2 Replies

Avatar

Level 2

 

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? 

Avatar

Level 5

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.