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 | Community
Skip to main content
B
BillPe
New Participant
January 31, 2024
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

  • January 31, 2024
  • 1 reply
  • 718 views

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.

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
Best answer by skyehansen

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-text-mode-filters-using-exists-statements.html?lang=en

1 reply

skyehansen
skyehansen
New Participant
January 31, 2024

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

B
BillPeAuthor
New Participant
January 31, 2024

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
skyehansenAccepted solution
New Participant
February 1, 2024

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-text-mode-filters-using-exists-statements.html?lang=en

    Terms & ConditionsAccessibility statement

    Loading footer...