Text Mode in Reporting: Eliminating parts of the data that appears | Community
Skip to main content
C
CT64839242323
Level 2
October 23, 2024
Question

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

  • October 23, 2024
  • 2 replies
  • 471 views

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

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.

2 replies

T
TealeMc4
Level 2
October 23, 2024

 

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
Community Advisor
Sven-iXCommunity Advisor
Community Advisor
October 23, 2024

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. 

Terms & ConditionsAccessibility statement

Loading footer...