Custom View - To Include Job Role

[MegSVT]

I have a custom view that I work from and I need it to show me one more thing (which I am so close!) but I need help. I am new to this, so really playing around with the API explorer and building in text mode. 

I found this code in reference collections and it did get me closer to what I was envisioning... but not exactly. I specifically want to include a column that shows the designer (job role) assigned to that project. The following code shows all the tasks with all the assignees, which is great, but not what I need. Can anyone point me in the right direction? 

valueformat=HTML

textmode=true

type=iterate

listdelimiter=<p>

displayname=Tasks Names - Primary Assignee

listmethod=nested(tasks).lists

valueexpression=CONCAT({name},' - ',{assignedTo}.{name})

[skyehansen]

congrats on unlocking the API explorer and collections.

It honestly seems like this post (below) might be a better option? (i.e. checking... if you really just want to know which designer is assigned to the proj then listing all the tasks is a bit overkill)

https://experienceleaguecommunities.adobe.com/t5/workfront-questions/adding-users-assigned-to-specif...

[MegSVT]

Thanks! I think my description of my question is not exactly accurate, haha, I am trying NOT to list all tasks and assignees - I just want the designer who was assigned to the project. I think one of the bigger hang-ups here is that i am trying to do this with a custom "view". 

Here was my quick fix - I built a custom form with all our designers and tossed that into the mix. I would really like to figure out how to build this certain column in - I am going to keep playing with it, especially that new option you've mentioned. 

[nryan2]

Here are a couple of options that you can try.

• The first one looks for users with the role that contains "Designer", I find that this one pulls in other roles we have that also contain "Designer".
• The second one uses the Role ID, so it will only pull the users with specific job role. You need to change the ID below to your Designer Role ID. 

displayname=Designer (Contains)

listdelimiter=<p>

listmethod=nested(projectUserRoles).lists

type=iterate

valueexpression=IF(CONTAINS('Designer',{role}.{name})=true,{user}.{name}," ")

valueformat=HTML

displayname=Designer Assigned (Role ID)

listdelimiter=<p>

listmethod=nested(projectUserRoles).lists

type=iterate

valueexpression=IF({role}.{ID}="a2b230b5f9a94762e040007f01005d712",{user}.{name}," ")

valueformat=HTML