Report to show when Task Owner does not equal Project Owner | Community
Skip to main content
C
CallyLa1
January 22, 2025
Solved

Report to show when Task Owner does not equal Project Owner

  • January 22, 2025
  • 1 reply
  • 615 views

Hello,

As part of our resourcing process we assign a particular role on the project as the project Owner. We assign all the tasks first (as this is often done in advance and as part of the planning) and then when we're ready I want to generate a report of all the projects where this role is NOT yet the owner. We have a consistent task (called, Deploy Survey) on all projects which is assigned to the role in question. I started a Task Report where I'm looking to compare the owner of that task and the project owner. If they do not match, I want to see that on the report. This report will become sort of a queue of projects that need our action. 

 

For my filter I currently have: 

assignedToID=project:ownerID assignedToID_Mod=ne name=Deploy Survey name_Mod=cicontains project:status=CUR PLN project:status_Mod=in

 

It seems like it wants to work, but my report still generates 100% of my projects regardless of whether those two assignments match or not. 

 

Best answer by Richard_Le_

Hey,

 

Looks like you are nearly there. Since you are filtering one field against another, you need to tell Workfront you are doing this by adding "FIELD:" to your filter criteria. So "assignedToID=project:ownerID" will become "assignedToID=FIELD:project:ownerID"

 

assignedToID=FIELD:project:ownerID assignedToID_Mod=ne name=Deploy Survey name_Mod=cicontains project:status=CUR PLN project:status_Mod=in

 

Let me know if this works.

Best Regards,

Rich.

1 reply

R
Community Advisor
Richard_Le_Community AdvisorAccepted solution
Community Advisor
January 22, 2025

Hey,

 

Looks like you are nearly there. Since you are filtering one field against another, you need to tell Workfront you are doing this by adding "FIELD:" to your filter criteria. So "assignedToID=project:ownerID" will become "assignedToID=FIELD:project:ownerID"

 

assignedToID=FIELD:project:ownerID assignedToID_Mod=ne name=Deploy Survey name_Mod=cicontains project:status=CUR PLN project:status_Mod=in

 

Let me know if this works.

Best Regards,

Rich.

C
CallyLa1Author
January 22, 2025

Thank you, Rich. That makes sense. Unfortunately now I am getting 0 results, when I know there should have a couple hundred. 

R
Community Advisor
Richard_Le_Community Advisor
Community Advisor
January 22, 2025

Hey,

 

That's strange, it works in my instance.

 

Can you make sure that there is a Tab character inbetween "CUR" and "PLN"? Tab characters don't copy over from experience league into Workfront, so if you've done a straight copy and paste of my code this might be the problem.

 

Best Regards,

Rich

 

Terms & ConditionsAccessibility statement

Loading footer...