Anyone want to help me write an EXISTS filter for my Program Report? | Community
Skip to main content
MoniqueEvans
MoniqueEvans
New Participant
Aug 18, 2022 6:34 PM UTC
Solved

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

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.
-JC
-JCAccepted solution
Level 5
Aug 18, 2022 9:56 PM UTC

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 reply

2 replies

-JC
-JCAccepted solution
Level 5
Aug 18, 2022 9:56 PM UTC

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!

Translate
    MoniqueEvans
    MoniqueEvansAuthor
    New Participant
    Aug 19, 2022 3:12 PM UTC

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

    Translate
    Terms & ConditionsAccessibility statement

    Loading footer...