I am trying to pull a task assignment report that lists the project name and project owner name - stumped! | Community
Skip to main content
B
Beth_Dawson
March 26, 2025
Solved

I am trying to pull a task assignment report that lists the project name and project owner name - stumped!

  • March 26, 2025
  • 2 replies
  • 597 views

@nicholevargas I know I saw a few questions with something similar, but not exactly what I need.

 

I am replacing someone and need to pull a report that lists:

Project name

Project Owner

Task name contains "closeout"

Task status is not complete

Task status is late

 

I've tried a project, task and assignment report but can't seem to pull everything in that I need. 

 

Can someone help - I'm horrible at textmode!

 

Thanks,

Beth Dawson

Best answer by Srinija_N

A Task report should work, you will be able to pull the project details as well.

 

 

 

 

text mode for Project Owner name:

valuefield=project:owner:name
valueformat=HTML
linkedname=project
namekey=view.relatedcolumn
namekeyargkey2=name
namekeyargkey.0=project
namekeyargkey.1=owner
querysort=project:owner:name

 

Hope this helps!

 

Please my post as 'Correct reply' if it helped you and also to help others.

Thanks!!

2 replies

Srinija_N
Srinija_NAccepted solution
Level 7
March 26, 2025

A Task report should work, you will be able to pull the project details as well.

 

 

 

 

text mode for Project Owner name:

valuefield=project:owner:name
valueformat=HTML
linkedname=project
namekey=view.relatedcolumn
namekeyargkey2=name
namekeyargkey.0=project
namekeyargkey.1=owner
querysort=project:owner:name

 

Hope this helps!

 

Please my post as 'Correct reply' if it helped you and also to help others.

Thanks!!

    B
    Beth_DawsonAuthor
    March 26, 2025

    Thank you - I just needed the text mode fields - appreciate you rapid respone!

    NicholeVargas
    Adobe Employee
    NicholeVargasAdobe Employee
    Adobe Employee
    March 26, 2025

    @beth_dawson Looks like @srinija_n offered a solution below, which I'd also recommend! To just add on, whenever you are wanting to pull in multiple Workfront objects to a report (ex: both tasks and projects), I recommend starting off with the object that has the 1:1 relationship, which in this case would be a Task Report. Because a task can only be associated with one project (1:1 relationship) versus a project having many tasks (1:many relationship/collections), the latter option will require text mode to pull both objects into a report whereas the 1:1 relationships would not. 

    Hopefully that provides some clarification! 

      Terms & ConditionsAccessibility statement

      Loading footer...