I need help pulling a specific information for a column for one of our job roles. What would I use as a text mode in order to pull "Creative Project Manager" job role from our database? I am pulling a project report to know which PM's are on which project without having to go into each project.
Solved! Go to Solution.
Views
Replies
Total Likes
Try this instead:
displayname=PM's On This Project listdelimiter=<br> listmethod=nested(projectUsers).lists textmode=true type=iterate valueexpression=IF({user}.{roleID}="INSERT ROLE ID HERE",{user}.{name}) valueformat=HTML
That should work.
How is the PM indicated on your projects, via a custom field or are they the owner? If they're on a task on the project then you may be able to use assignments.
Views
Replies
Total Likes
They are not the owners of the project but they are one of many assigned to multiple tasks.
Views
Replies
Total Likes
You will probably need a task report and show a column for assignments. Then you can filter via Assignment Roles > ID to narrow it down to Creative Project Manager.
Views
Replies
Total Likes
Will I still be able to pull all of the fields in the picture?
Views
Replies
Total Likes
You should be able to get to all project fields from a task report.
Views
Replies
Total Likes
I tried that and it still will not pull the CPM that I need and it is also listing the project name multiple times.
Views
Replies
Total Likes
Hi,
You will be able to achieve this with the following text mode:
listdelimiter=<br> valueexpression=IF(CONTAINS(“Creative Project Manager”,{user}.{role}.{name}),{user}.{name}) listmethod=nested(projectUsers).lists valueformat=HTML displayname=PM's On This Project textmode=true type=iterate
Using the above code, Workfront will return any members of the project team (i.e., anyone assigned to tasks, the owner, or sponsor) who have Creative Project Manager as their primary role.
Best Regards,
Rich.
I tried this and the column is still showing blank, even though when I click into the jobs, there are users listed as Creative Project Manager. So I am not sure why it is not pulling their name.
Views
Replies
Total Likes
Do these users have Creative Project Manager set as their primary role in the system, or are they secondary roles?
Views
Replies
Total Likes
Primary
Views
Replies
Total Likes
Try this instead:
displayname=PM's On This Project listdelimiter=<br> listmethod=nested(projectUsers).lists textmode=true type=iterate valueexpression=IF({user}.{roleID}="INSERT ROLE ID HERE",{user}.{name}) valueformat=HTML
That should work.
That Worked! Thank you!
Views
Replies
Total Likes
You're very welcome, glad I could help.
Views
Replies
Total Likes
Hi Richard,
Do you know what would be the expression if I wanted to filter a Typeahead Field (User) but I only want it to display Users with the Access Level: Project Manager?
Views
Replies
Total Likes
Hi,
The filter you would use in your typeahead field is as follows:
accessLevelID=INSERT ACCESS LEVEL ID HERE
accessLevelID_Mod=in
Regards,
Rich
Views
Replies
Total Likes
Thanks so much!! I was using:
accessLevelMM:ID= XXXXXXXX
accessLevelMM:ID_Mod=in
Obviously that didn't work.. but at least I was close.. haha.
Thanks, again!
Views
Replies
Total Likes
hello @Richard_Le_ -- dredging this up after quite some time, but how would we call up multiple roles for this? For instance, I need to represent both 'Designer' and 'Sr. Art Director' in a single 'Creative' column. I assume that there needs to be an 'or' statement somewhere in here.
This possible?
Views
Replies
Total Likes
Views
Like
Replies