Betreff: Create project report filter to only show projects that don't have any tasks that match my custom criteria

[Jeremy_Seattle]

Hello,

Here's what a I want from my project report:

1st criteria: Only show projects from my teams portfolio

2nd criteria: Only show projects that are in work

3rd criteria: Only show projects where the following statement is FALSE for each task: (task is in work AND "My custom task field" = "Custom value")

I can't seem to work that 3rd criteria in.  I've tried a number of different ways to accomplish this in text mode but i haven't found a solution that works.

[lgaertner · Accepted solution]

Hello Jeremy,

I hope this text mode will lead you in the right direction:

EXISTS:a:$$EXISTSMOD=EXISTS
EXISTS:a:$$OBJCODE=TASK
EXISTS:a:DE:<customFieldName>=abc123
EXISTS:a:projectID=FIELD:ID
EXISTS:a:status=INP

Regards

Lars

[Jeremy_Seattle]

It sure did!  Thank you.  That was a huge help.  Here is the code I used:

AND:a:EXISTS:a:$$EXISTSMOD=NOTEXISTS
AND:a:EXISTS:a:$$OBJCODE=TASK
AND:a:EXISTS:a:DE:<my custom field>=<a specific value>
AND:a:EXISTS:a:projectID=FIELD:ID
AND:a:EXISTS:a:status=INP
EXISTS:a:$$EXISTSMOD=NOTEXISTS
EXISTS:a:$$OBJCODE=TASK
EXISTS:a:DE:<my custom field>=<a specific value>
EXISTS:a:projectID=FIELD:ID
EXISTS:a:status=NEW
portfolioID=<my portfolio id>
portfolioID_Mod=in
status=CUR
status_Mod=in