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

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

  • August 18, 2022
  • 2 replies
  • 510 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!

2 replies

-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
Adobe Champion and Community Advisor
Adobe Champion and Community Advisor
August 19, 2022

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