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
  • 615 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!!

If this helped to solve your problem, please mark it as 'solved' so others can also find the solution faster. 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...