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

[Rianne1]

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"

[Femke_Crijns · Accepted solution]

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?

[Rianne1]

I think this works! Thank you! 

[Rianne1]

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

[Femke_Crijns]

Hi,

I'm not familiar with Proof at all, unfortunately. Hopefully, someone else in this community knows how this relates to Proof settings.