Anyone want to help me write an EXISTS filter for my Program Report? | Community
Skip to main content
MoniqueEvans
Community Advisor
Community Advisor
August 18, 2022
Solved

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

  • August 18, 2022
  • 1 reply
  • 484 views

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.

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

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!

1 reply

-JC
-JCAccepted solution
Level 6
August 18, 2022

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!

MoniqueEvans
Community Advisor
Community Advisor
August 19, 2022

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