I am trying to create a report that lists the "people" in templates (this is the list you get if you check people in the left panel of a template). I have been unable to find the field name for People in Templates. Any assistance is appreciated

[BillPe]

I am trying to create a report that lists the "people" in templates (this is the list you get if you check people in the left panel of a template). I have been unable to find the field name for People in Templates. Any assistance is appreciated.

[skyehansen]

the api explorer says it's templateUsers, so I would suggest using something like this.

listdelimiter=<br>
valuefield=user:name
listmethod=nested(templateUsers).lists
valueformat=HTML
displayname=Project Team
textmode=true
type=iterate

[BillPe]

Thank you Skye that works for displaying the list

However, I would like to filter only if the names in the list contain and of the following:

Debbie Baker

Becka Gauthier

Ann Weaver

Crystal Beller

What would the filter look like?

[skyehansen · Accepted solution]

the filter would need to be an exists statement. Again, you would use the API Explorer to discover everything you need for this. Clicking into the Template Users listing you can clearly see the object code and all the fields being kept in this table. The relevant fields would be the template ID, since this is a possible joining point, and the user ID, which is how you are identifying your user. A sample exists statement might look like the below:

EXISTS:a:$$OBJCODE=TMTU
EXISTS:a:templateID=FIELD:ID
EXISTS:a:userID=your four user IDs, all separated with tabs

In plain english, this kind of text translates to:

line 1 -- show me any template team member (i.e. person in the people section of a project template)...

line 2 -- where the template ID on that template team member is equal to the ID field on your template report...

line 3 -- and the users I'm looking for are Debbie, Becka, Ann and Crystal

Please read up on exists statements here:

https://experienceleague.adobe.com/docs/workfront/using/reporting/reports/text-mode/create-complex-t...

[Doug_Den_Hoed__AtAppStore]

Great stuff @skyehansen,

Isn't awesome to have more and more people who can beat us to Right Answers?

Regards,

Doug 

[skyehansen]

I actually just signed up for a few reporting classes to see where they stop. I feel like someone somewhere should give classes on collections and exists statements -- these are the questions that come up often in AEL. But other than Jason's classes and WF documentation, I don't know where else to send users to get trained.