Join the #BuildWithBuildAgent Challenge! Get recognized, earn exclusive swag, and inspire the ServiceNow Community with what you can build using Build Agent.  Join the Challenge.

If a Project, has subprojects, I would like to omit the Parent project from the reports

Nadz
Kilo Contributor

3 weeks ago

If a Project, has subprojects, I would like to omit the Parent project from the reports and show only the subprojects so for example if Project A has subprojects B, C and D, when I run my report, I would like for B,C and D only to show up. 

I cannot use the filter of "Parent is something" as some of the Projects will not have subprojects so should show on that report.

Thank you for any help

0 Helpfuls
  • 185 Views
1 REPLY 1

M Iftikhar
Tera Sage

Friday

Hi @Nadz,

You can generate that report by using a Related List Condition, which allows you to exclude any project that has subprojects. This way:

  • Projects with subprojects (like A) will be omitted.
  • Projects without subprojects (or the subprojects themselves B, C, D) will still appear.

Set it up using the related list condition on the Project → Parent relationship, as shown in the screenshot below.

MIftikhar_0-1763737808998.png

 

If my response helped, please mark it as the accepted solution so others can benefit as well.

 

Thanks & Regards,
Muhammad Iftikhar

If my response helped, please mark it as the accepted solution so others can benefit as well.