Expand my Community achievements bar.

SOLVED

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

Avatar

Level 1

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"

 

Topics

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

1 Accepted Solution

Avatar

Correct answer by
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?

View solution in original post

4 Replies

Avatar

Correct answer by
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?

Avatar

Level 1

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

Avatar

Level 4

Hi,

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