Expand my Community achievements bar.

The next phase for Workfront Community ideas is coming soon. Learn all about it in our blog!

Project Report: Project Owner ID = Entered by ID

Avatar

Level 8
I'm trying to create a report that shows Active projects where the Project Owner ID equals the Entered by ID (that they are same user in both regards). I can't seem to get filters right to show this. I assume that this has be done via Text Mode but everything I try gives zero results when I know there are results. Does anyone know if this is possible? And if so, what I have to put into the report filter to make it work correctly and generate these results? Thanks!
Topics

Topics help categorize Community content and increase your ability to discover relevant content.

5 Replies

Avatar

Level 7
This should work: ownerID=FIELD:enteredByID ownerID_Mod=eq

Avatar

Level 8
Thanks, Greg. That works perfectly!

Avatar

Level 6
Is there a way to do the opposite? Where we can see if the Entered By and Primary Owner aren't the same person? I couldn't get this to work for me. ownerID=FIELD:enteredByID ownerID_Mod=notin

Avatar

Level 3
Hi Vincent, The following should work: ownerID=FIELD:enteredByID ownerID_Mod=ne Kathy

Avatar

Level 6
Thank you, Kathy! That worked perfectly!