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

Looking to create a report that will pull in Programs that are empty

Avatar

Level 4

Good afternoon,

I am trying to create a report that will show me programs that do not have any projects opened under it. I took the EXSISTs filter for projects and tried to modify for Program, but I get an error. Does anyone have any insight?

EXISTS:a:$$EXISTSMOD=NOTEXISTS

EXISTS:a:$$OBJCODE=PROJ

EXISTS:a:programID=FIELD:ID

EXISTS:b:$$EXISTSMOD=NOTEXISTS

EXISTS:b:$$OBJCODE=DOCU

EXISTS:b:programID=FIELD:ID

EXISTS:c:$$EXISTSMOD=NOTEXISTS

I am also wanting to create a report that will show me programs that have all of their projects complete or cancelled, but I have not been able to get that to work either.

Thank you!

Topics

Topics help categorize Community content and increase your ability to discover relevant content.

1 Accepted Solution

Avatar

Correct answer by
Level 8

Hi Kristina, try this for no projects in a program:

EXISTS:a:$$EXISTSMOD=NOTEXISTS

EXISTS:a:$$OBJCODE=PROJ

EXISTS:a:programID=FIELD:ID

View solution in original post

0 Replies

Avatar

Correct answer by
Level 8

Hi Kristina, try this for no projects in a program:

EXISTS:a:$$EXISTSMOD=NOTEXISTS

EXISTS:a:$$OBJCODE=PROJ

EXISTS:a:programID=FIELD:ID

Avatar

Level 4

Thank you! That worked. I just needed to add in a filterto remove Inactive ones and I got what I needed.

Avatar

Level 9

Hi @Kristina Walton‚

Could you please explain how you created this report, for example which type of report + view + grouping + filter, etc.?

Thanks you in advance.

Best regards,

Kundan

Avatar

Level 4

Hi Kundan,

I used a Program report and below is the custom text I used. I have this only pulling in programs that are active:

EXISTS:a:$$EXISTSMOD=NOTEXISTS

EXISTS:a:$$OBJCODE=PROJ

EXISTS:a:programID=FIELD:ID

EXISTS:b:$$EXISTSMOD=NOTEXISTS

EXISTS:b:$$OBJCODE=DOCU

EXISTS:b:programID=FIELD:ID

isActive=true

isActive_Mod=eq

name=Quality

name_Mod=cinotcontains

My report is then grouped by Program owner and I have the Owner, Description and Entry Date showing in the view. But that can all be customized to show the data that you are looking for.

Hope this helps.

Kristina