project owner filter on a proof approval report | Community
Skip to main content
Level 4
November 16, 2023
Question

project owner filter on a proof approval report

  • November 16, 2023
  • 1 reply
  • 943 views

Hi All,

Creating a proof approval report, but I need the report to use a project owner filter (this isn't an option when creating filters for this type of report). Looking for assistance on how to generate the correct code in the filter to only bring back proof approvals on a particular project owner's projects.

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.

1 reply

Community Advisor
November 16, 2023

Hi Seth,

 

I haven't fully tested this, but in theory this text mode should work as a filter on a proof approval report:

 

EXISTS:1:$$OBJCODE=PROJ EXISTS:1:documents:currentVersionID=FIELD:documentVersionID EXISTS:1:ownerID=INSERT PROJECT OWNERID HERE

 

Let me know how you get on.

 

Best Regards,

Rich.

Level 4
November 16, 2023

Thanks Richard, 

This is a good start.  However, it's still pulling in projects from different owners and projects that have already been completed.  Any way to remove those?