report - universal view of my people's work | Adobe Higher Education
Skip to main content
Level 2
April 29, 2026
Vraag

report - universal view of my people's work

  • April 29, 2026
  • 1 reactie
  • 14 Bekeken

Hi!
I am using the cookbook’s “My People's Work Universal Dashboard” and trying to recreate Project Open Projects.

workfront-customer-reporting-cookbook.pdf

I created the Manager Hierarchy form and calculated field. I then created a project report and placed this text into the filter, with the only change being the field name.
 

DE:owner:X Manager Hierarchy=$$USER.nameDE:owner:X Manager Hierarchy_Mod=cicontainsOR:1:ownerID=$$USER.IDOR:1:ownerID_Mod=inOR:1:statusEquatesWith=CUR PLN ONHOR:1:statusEquatesWith_Mod=instatusEquatesWith=CUR PLN ONHstatusEquatesWith_Mod=in

 

I am trying to pull a list of all projects of all users the director manages, regardless if the user owns the project or not. They can just be on the project (not just own it). 

 

However, the report is blank when I view it as a director. Any thoughts or fixes?

1 reactie

skyehansen
Community Advisor and Adobe Champion
April 29, 2026

I can’t tell from your post whether or not you attached the form to any of your users. If you did, did that field populate? Also, can you go back to your original post and put the filter text in a code block? Otherwise the line breaks do not appear to come through on my side, and makes it hard to read.

AlvinaLa1Auteur
Level 2
April 29, 2026

Hi, yes my users have the forms attached to them.

 

The field populated something that looked like

John Smith - Jane Smith - John Doe - Alvina La

 

DE:owner:MPR Manager Hierarchy=$$USER.name
DE:owner:MPR Manager Hierarchy_Mod=cicontains
OR:1:ownerID=$$USER.ID
OR:1:ownerID_Mod=in
OR:1:statusEquatesWith=CUR PLN ONH
OR:1:statusEquatesWith_Mod=in
statusEquatesWith=CUR PLN ONH
statusEquatesWith_Mod=in

 

skyehansen
Community Advisor and Adobe Champion
April 29, 2026

Can you tell me whether the CUR / PLN / ONH line has tabs between the acronyms? Or just spaces?

 

Actually, can you just take everything off except for the first 2 lines in the filter, and see if those work?