Looking to create a report that will pull in Programs that are empty | Community
Skip to main content
K
KristinaWa1
Level 3
July 13, 2020
Solved

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

  • July 13, 2020
  • 1 reply
  • 682 views

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!

    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 AdinaPi1

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

    EXISTS:a:$$EXISTSMOD=NOTEXISTS

    EXISTS:a:$$OBJCODE=PROJ

    EXISTS:a:programID=FIELD:ID

    1 reply

    A
    AdinaPi1Accepted solution
    Level 9
    July 13, 2020

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

    EXISTS:a:$$EXISTSMOD=NOTEXISTS

    EXISTS:a:$$OBJCODE=PROJ

    EXISTS:a:programID=FIELD:ID

      K
      KristinaWa1Author
      Level 3
      July 13, 2020

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

      K
      KristinaWa1Author
      Level 3
      November 5, 2020

      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

      Terms & ConditionsAccessibility statement

      Loading footer...