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

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

  • August 18, 2022
  • 1 reply
  • 497 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 and Adobe Champion
Community Advisor and Adobe Champion
August 19, 2022

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