<?xml version="1.0" encoding="UTF-8"?>
<rss xmlns:content="http://purl.org/rss/1.0/modules/content/" xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:rdf="http://www.w3.org/1999/02/22-rdf-syntax-ns#" xmlns:taxo="http://purl.org/rss/1.0/modules/taxonomy/" version="2.0">
  <channel>
    <title>topic Re: Anybody know the text code to list out in a single column all Job Roles assigned to a user in a User report? in Workfront Questions</title>
    <link>https://experienceleaguecommunities.adobe.com/t5/workfront-questions/anybody-know-the-text-code-to-list-out-in-a-single-column-all/m-p/495859#M27643</link>
    <description>&lt;P&gt;Thanks Chloe!&lt;/P&gt;</description>
    <pubDate>Mon, 27 Sep 2021 18:53:43 GMT</pubDate>
    <dc:creator>NatalieBo</dc:creator>
    <dc:date>2021-09-27T18:53:43Z</dc:date>
    <item>
      <title>Anybody know the text code to list out in a single column all Job Roles assigned to a user in a User report?</title>
      <link>https://experienceleaguecommunities.adobe.com/t5/workfront-questions/anybody-know-the-text-code-to-list-out-in-a-single-column-all/m-p/495857#M27641</link>
      <description>&lt;P&gt;I'm building a user report that shows the alignment of users to their respective groups and job roles. I am displaying their primary job roles, but for some teams, they have many job roles. I'm trying to create a column that displays all job roles a user is aligned to.&lt;/P&gt;&lt;P&gt; &lt;/P&gt;&lt;P&gt;Here's the code to list out all groups associated to a user... tried to use this and replicate for Job Roles, but couldn't get there. Thanks!&lt;/P&gt;&lt;P&gt;displayname=All Groups Assigned&lt;/P&gt;&lt;P&gt;&lt;A href="http://link.linkproperty.0.name/" alt="http://link.linkproperty.0.name/" target="_blank"&gt;link.linkproperty.0.name&lt;/A&gt;=ID&lt;/P&gt;&lt;P&gt;link.linkproperty.0.valuefield=ID&lt;/P&gt;&lt;P&gt;link.linkproperty.0.valueformat=int&lt;/P&gt;&lt;P&gt;link.lookup=link.view&lt;/P&gt;&lt;P&gt;link.value=val(objCode)&lt;/P&gt;&lt;P&gt;listdelimiter=&lt;/P&gt;&lt;P&gt;listmethod=nested(userGroups).lists&lt;/P&gt;&lt;P&gt;namekey=group.plural&lt;/P&gt;&lt;P&gt;textmode=true&lt;/P&gt;&lt;P&gt;type=iterate&lt;/P&gt;&lt;P&gt;valuefield=group:name&lt;/P&gt;&lt;P&gt;valueformat=HTML&lt;/P&gt;&lt;P&gt;width=250&lt;/P&gt;</description>
      <pubDate>Thu, 23 Sep 2021 17:39:29 GMT</pubDate>
      <guid>https://experienceleaguecommunities.adobe.com/t5/workfront-questions/anybody-know-the-text-code-to-list-out-in-a-single-column-all/m-p/495857#M27641</guid>
      <dc:creator>NatalieBo</dc:creator>
      <dc:date>2021-09-23T17:39:29Z</dc:date>
    </item>
    <item>
      <title>Re: Anybody know the text code to list out in a single column all Job Roles assigned to a user in a User report?</title>
      <link>https://experienceleaguecommunities.adobe.com/t5/workfront-questions/anybody-know-the-text-code-to-list-out-in-a-single-column-all/m-p/495858#M27642</link>
      <description>&lt;P&gt;Hi Natalie!&lt;/P&gt;&lt;P&gt; &lt;/P&gt;&lt;P&gt;This should get you what you're looking for:&lt;/P&gt;&lt;P&gt; &lt;/P&gt;&lt;P&gt;displayname=Role(s)&lt;/P&gt;&lt;P&gt;listdelimiter=&lt;/P&gt;&lt;P&gt;listmethod=nested(userRoles).lists&lt;/P&gt;&lt;P&gt;textmode=true&lt;/P&gt;&lt;P&gt;type=iterate&lt;/P&gt;&lt;P&gt;valuefield=role:name&lt;/P&gt;&lt;P&gt;valueformat=HTML&lt;/P&gt;&lt;P&gt; &lt;/P&gt;&lt;P&gt;If you want to have the roles in the column separated by line breaks/carriage returns, add &amp;lt;br&amp;gt; to your listdelimiter (ex: listdelimiter=&amp;lt;br&amp;gt;).&lt;/P&gt;&lt;P&gt; &lt;/P&gt;&lt;P&gt;-----------------------------------&lt;/P&gt;&lt;P&gt; &lt;/P&gt;&lt;P&gt;If you want to get really technical, you swap out valuefield for a valueexpression. This would only return the "Other" roles (and not the primary role). Could be helpful if you want to have a column for the primary role and then a separate column that shows any other role(s) that a user may have:&lt;/P&gt;&lt;P&gt; &lt;/P&gt;&lt;P&gt;displayname=Other Role(s)&lt;/P&gt;&lt;P&gt;listdelimiter=&lt;/P&gt;&lt;P&gt;listmethod=nested(userRoles).lists&lt;/P&gt;&lt;P&gt;textmode=true&lt;/P&gt;&lt;P&gt;type=iterate&lt;/P&gt;&lt;P&gt;valueexpression=IF({user}.{role}={role}.{name},"",{role}.{name})&lt;/P&gt;&lt;P&gt;valueformat=HTML&lt;/P&gt;</description>
      <pubDate>Thu, 23 Sep 2021 22:54:30 GMT</pubDate>
      <guid>https://experienceleaguecommunities.adobe.com/t5/workfront-questions/anybody-know-the-text-code-to-list-out-in-a-single-column-all/m-p/495858#M27642</guid>
      <dc:creator>ChloeRo</dc:creator>
      <dc:date>2021-09-23T22:54:30Z</dc:date>
    </item>
    <item>
      <title>Re: Anybody know the text code to list out in a single column all Job Roles assigned to a user in a User report?</title>
      <link>https://experienceleaguecommunities.adobe.com/t5/workfront-questions/anybody-know-the-text-code-to-list-out-in-a-single-column-all/m-p/495859#M27643</link>
      <description>&lt;P&gt;Thanks Chloe!&lt;/P&gt;</description>
      <pubDate>Mon, 27 Sep 2021 18:53:43 GMT</pubDate>
      <guid>https://experienceleaguecommunities.adobe.com/t5/workfront-questions/anybody-know-the-text-code-to-list-out-in-a-single-column-all/m-p/495859#M27643</guid>
      <dc:creator>NatalieBo</dc:creator>
      <dc:date>2021-09-27T18:53:43Z</dc:date>
    </item>
  </channel>
</rss>

