Solved

Task report filtered by Program Owner ID $$USER.ID

How do I text mode filter a TASK report to show only the PROGRAMS that the user owns (Program Owner ID)?

As well as having these 2 filters:

Project >> Status Equates With >> Equal Planning

and

Assignment Users >> Role ID >> Equal "one of the role names"

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

FemkeCrAccepted solution

Level 4

Hi,

To filter all tasks within programs of a specific Program Owner ID, you could use the following text mode in a TASK report:

EXISTS:A:$$OBJCODE=PROJ
EXISTS:A:ID=FIELD:projectID
EXISTS:A:program:ownerID=$$USER.ID

You could start by having all your other filters already set up, then change to text mode and paste the three lines in there.

Does this work?

FemkeCrAccepted solution

Level 4

Hi,

To filter all tasks within programs of a specific Program Owner ID, you could use the following text mode in a TASK report:

EXISTS:A:$$OBJCODE=PROJ
EXISTS:A:ID=FIELD:projectID
EXISTS:A:program:ownerID=$$USER.ID

You could start by having all your other filters already set up, then change to text mode and paste the three lines in there.

Does this work?

Translate

I think this works! Thank you! 🙌

Translate

@femkecr do you know how I would need to/could amend this to get it to work on a PROOF APPROVAL report?

Translate

Sign up