Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
Bedrock Mission!

Learn more

View all

Sign in to view all badges

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 2

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 2

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.