Comma-separated changed to one-per-line

[CalvinFold]

"https://community.workfront.com/discussions/community-home/digestviewer/viewthread?MessageKey=87cd3207-2ecd-415b-b959-556f9a07edb1&CommunityKey=ccf3381b-a473-4ef2-9f81-4dd3244cf522&tab=digestviewer#bm87cd3207-2ecd-415b-b959-556f9a07edb1" https://community.workfront.com/discussions/community-home/digestviewer/viewthread?MessageKey=87cd32... Melinda Layten Technical Project Manager - API and Integration Workfront

[TerryHy]

I think it is this in text mode: listdelimiter=

Terry Hynd EBSCO Information Services

[CalvinFold]

So this didn't work, and I found a thread about listdelimiter and tried and ​ but those didn't work either. Is this because I'm trying to do this in a View instead of a Report? Because it's a User view and field specifically? Kevin Quosig

[NRYNR]

Hi Kevin, The ""https://wf-pro.com/how-to/how-to-add-a-collection-to-a-view/">How to Add a Collection to a View " article has some list delimiters that you can try. Please include the full text in your view so we can better assist. Thanks, Narayan

[CalvinFold]

Here it is: displayname=Other Teams linkedname=direct listdelimiter=

namekey=teamsListString textmode=true tile.name=component.teamsList valuefield=teamsListString valueformat=HTML viewalias=team The above code does not make any change in the way teamListString displays: as comma-delimited. Kevin Quosig

[TerryHy]

Kevin, I think i got it. In your report, add a new Column and then enter this text mode: displayname=Other Teams listdelimiter=

listmethod=nested(teams).lists textmode=true type=iterate valuefield=name valueformat=HTML I tested this out using a User report, and it worked for me. It shows the teams a person is on and has the teams one on each line. Terry Hynd EBSCO Information Services

[MelindaLa1]

"https://community.workfront.com/discussions/community-home/digestviewer/viewthread?MessageKey=87cd3207-2ecd-415b-b959-556f9a07edb1&CommunityKey=ccf3381b-a473-4ef2-9f81-4dd3244cf522&tab=digestviewer#bm87cd3207-2ecd-415b-b959-556f9a07edb1" https://community.workfront.com/discussions/community-home/digestviewer/viewthread?MessageKey=87cd32... Melinda Layten Technical Project Manager - API and Integration Workfront

[CalvinFold]

Terry: Yours worked, but an odd side-effect...bolds all the data. Any idea why that might be? Melinda: I didn't try your solve because I'm quite sure I'd forget to add-back that "\" every time I edit...I'm still to new at this and Workfront isn't my full-time responsibility. ;-) Though it does give me something for the Idea Exchange...the ability to add coding comments to the text mode... Kevin Quosig

[CalvinFold]

So I tried this with Resource Managers and...back to square-one. Apparently I haven't picked-up on changing the syntax to fit the field/data in question. :-( Throw a guy another example? Maybe elucidate on how you're figuring this out? Kevin Quosig

[TerryHy]

I don't think you can do the same thing for Resource Managers as you can for Teams on a User Report, as Resource Manager is not a 'job role' but a project/template field in WF. And, Resource Manager is not an option as a referenced collection associated to a User through the API Explorer ( https://experience.workfront.com/s/api-explorer ), so not able to do the same thing as was done with Teams above with the 'nested' capability. (I tested it out and no luck.) However, if you ran a Project or Template report, you could pull in the listed Resource Managers on a project or template by using Project --> Resource Managers or Template --> Resource Managers respectively. Terry Hynd EBSCO Information Services

[CalvinFold]

Actually, it is a project report...and using Project » Resource Managers . ;-) So if this is the syntax... displayname=Other Teams listdelimiter=

listmethod=nested(teams).lists textmode=true type=iterate valuefield=name valueformat=HTML ...what goes in place of teams and how did you determine that? Kevin Quosig

[MelindaLa1]

So the basic syntax is: displayname= listdelimiter=

listmethod=nested().lists textmode=true type=iterate valuefield= valueformat=HTML Displayname can be any text that can name the column so Resource Managers Text Mode For the listmethod: First I go the api explorer: "https://developersupport.workfront.com/page-api-explorer.html" https://developersupport.workfront.com/page-api-explorer.html Then I go to the Project object and click on the collections tab. There I look for Resource Managers and to the right it says this collection is called resourceManagers and that is what goes in the listmethod parentheses. So far: displayname=Resource Managers Text Mode listdelimiter=

listmethod=nested(resourceManagers).lists textmode=true type=iterate valuefield= valueformat=HTML Now for the valuefield you need to go into the Resource Manager object. You'll notice that this is a cross-reference table and only has the ID of our Resource Manager and not their name. So now I go to the references tab and see that the Resource Manager = resourceManager and that's a user object which has a name. So valuefield=resourceManager.name displayname=Resource Managers listdelimiter=

listmethod=nested(resourceManagers).lists textmode=true type=iterate valuefield=resourceManager.name valueformat=HTML I then test it in a report alongside the built in Resource Managers list and get: Melinda Layten Technical Project Manager - API and Integration Workfront

[CalvinFold]

Melinda, thanks for the walkthrough! Kevin Quosig

[CalvinFold]

Okay, I think everyone is going to love this...maybe a bug? Melinda's code above, for me, ONLY works if the Resource Manager is ALSO listed in an unedited column on the view. If I remove the boring, unedited Resource Manager column, the fancy, text mode version stops working (values go blank). Kevin Quosig