Looking to create a report that will pull in Programs that are empty | Adobe Higher Education
Skip to main content
Level 3
July 13, 2020
解決済み

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

  • July 13, 2020
  • 1 の返信
  • 682 ビュー

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!

このトピックへの返信は締め切られました。
ベストアンサー 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 の返信

AdinaPi1回答
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

KristinaWa1作成者
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.

Kundanism
Level 10
November 5, 2020

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