Displaying Specific Roles (in a column) On An Assignment Report | Community
Skip to main content
Eric_D_Miller
Eric_D_Miller
Level 5
March 12, 2025
Solved

Displaying Specific Roles (in a column) On An Assignment Report

  • March 12, 2025
  • 1 reply
  • 373 views

Hello,

 

I am trying to configure a textmode column to display who is filling certain roles on a project. I have this textmode to get it working on a project report but I am unsure how to tweak it for an assignment report. Here is my code:

description=Team Users displayname=Creative Roles On Project link.linkproperty.0.name=ID link.linkproperty.0.valuefield=userID link.linkproperty.0.valueformat=int listdelimiter=<br> listmethod=nested(projectUsers).lists name=ID namekey=assignment.plural stretch=70 type=iterate valueexpression=IF({user}.{roleID}="53beed9c004ebf57e7a83caffa893a89" || {user}.{roleID}="58d97b9e004ada7cbf3e81ba6c649a48" || {user}.{roleID}="5d84f13e0063dd16b96fcb0c42f714df" || {user}.{roleID}="5458cd0300113c8b8b5f50f821bc6ddf" || {user}.{roleID}="5ab11c1200734f7fa047c04f062afe57" || {user}.{roleID}="53beee46004f251d355dc780bb32a84a" || {user}.{roleID}="5f6c9d7800186cbf89cec913fc61533f" || {user}.{roleID}="64beb1880006e8ec3ffc3d8e2d3f7834",CONCAT({user}.{name}," - ",{user}.{role})) valueformat=HTML width=150

I am guessing it has to do with my listdelimiter but I am unsure what to tweak.

Any help is greatly appreciated!

 

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

Hi, this text mode is for a collection of project users on a project. A "listdelimiter" is the separation between your results, when you have more than one result, as is normal for a collection.

 

In an assignment report, you do have the ability to only have one result (each assignment is made to a single user, and you have the ability to report on the role of that assignment), so a collection column isn't necessary, unless for some reason your goal is still to list the rest of the project team per assignment.

 

And, while it's possible to set up something that would indicate the role of the assignment in a column, it's just as easy (easier?) to simply filter for the 8 roles that you want. 

 

Can you clarify what you're looking for in this particular assignment report? i.e. are you pulling in unrelated assignments and thus need to only display specific roles? Otherwise, maybe it's enough to filter and then group by the role with no text mode needed? 

1 reply

skyehansen
Community Advisor and Adobe Champion
skyehansenCommunity Advisor and Adobe ChampionAccepted solution
March 12, 2025

Hi, this text mode is for a collection of project users on a project. A "listdelimiter" is the separation between your results, when you have more than one result, as is normal for a collection.

 

In an assignment report, you do have the ability to only have one result (each assignment is made to a single user, and you have the ability to report on the role of that assignment), so a collection column isn't necessary, unless for some reason your goal is still to list the rest of the project team per assignment.

 

And, while it's possible to set up something that would indicate the role of the assignment in a column, it's just as easy (easier?) to simply filter for the 8 roles that you want. 

 

Can you clarify what you're looking for in this particular assignment report? i.e. are you pulling in unrelated assignments and thus need to only display specific roles? Otherwise, maybe it's enough to filter and then group by the role with no text mode needed? 

Terms & ConditionsAccessibility statement

Loading footer...