Expand my Community achievements bar.

SOLVED

Anyone want to help me write an EXISTS filter for my Program Report?

Avatar

Community Advisor

I'm trying to create a Program Report that will only report out on programs that have a project with one of two specific custom forms attached (I can also attain the same result using template ID instead of category ID) but every time I try to write the EXISTS statement I get hung up.

1 Accepted Solution

Avatar

Correct answer by
Level 3

Hey Monique, something like this should work:

EXISTS:1:$$OBJCODE=PROJ
EXISTS:1:programID=FIELD:ID
EXISTS:1:templateID=yourtemplateIDhere
EXISTS:1:templateID_Mod=in
OR:a:EXISTS:1:$$OBJCODE=PROJ
OR:a:EXISTS:1:programID=FIELD:ID
OR:a:EXISTS:1:templateID=yourothertemplateIDhere
OR:a:EXISTS:1:templateID_Mod=in

Sub out the pink with your template IDs. Hope it helps!

View solution in original post

2 Replies

Avatar

Correct answer by
Level 3

Hey Monique, something like this should work:

EXISTS:1:$$OBJCODE=PROJ
EXISTS:1:programID=FIELD:ID
EXISTS:1:templateID=yourtemplateIDhere
EXISTS:1:templateID_Mod=in
OR:a:EXISTS:1:$$OBJCODE=PROJ
OR:a:EXISTS:1:programID=FIELD:ID
OR:a:EXISTS:1:templateID=yourothertemplateIDhere
OR:a:EXISTS:1:templateID_Mod=in

Sub out the pink with your template IDs. Hope it helps!

Avatar

Community Advisor

Thank you so much!! I had the second line backward.