Expand my Community achievements bar.

Do you have questions about the migration to Adobe Business Platform? Come join our upcoming coffee break and ask away!
SOLVED

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

Avatar

Level 3

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.

1 Accepted Solution

Avatar

Correct answer by
Community Advisor

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...

View solution in original post

5 Replies

Avatar

Community Advisor

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

Avatar

Level 3

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?

Avatar

Correct answer by
Community Advisor

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...

 

Great stuff @skyehansen,

 

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

 

Regards,

Doug 

Avatar

Community Advisor

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.