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

Report to display programs with active projects

Avatar

Level 9

Hi WF Community,

I'd like to generate a report that shows me all programs that have active projects within them.

* Active projects = project Status not in Deleted, Complete, Scoping Archived

* This must take into account that some programs might have completed projects AND active projects. These programs should show up on my report.

 

I'm thinking maybe this is a project report with an EXISTS in a text mode filter?  We don't deactivate programs, and we're yet to create a custom program Status field.

 

I'll continue to see if I can find a way, but any suggestions are welcomed.
Thanks,

Nick

1 Accepted Solution

Avatar

Correct answer by
Level 10

Hi Nick,

 

The below should do it. This will return all programs that have projects within them in active status, regardless of whether or not there are other projects in a closed status within that program

 

EXISTS:a:$$EXISTSMOD=EXISTS 
EXISTS:a:$$OBJCODE=PROJ 
EXISTS:a:programID=FIELD:ID 
EXISTS:a:status=CUR + ANY OTHER STATUSES THAT REPRESENT ACTIVE IN YOUR INSTANCE
EXISTS:a:status_Mod=in

Best Regards,

Rich

View solution in original post

2 Replies

Avatar

Correct answer by
Level 10

Hi Nick,

 

The below should do it. This will return all programs that have projects within them in active status, regardless of whether or not there are other projects in a closed status within that program

 

EXISTS:a:$$EXISTSMOD=EXISTS 
EXISTS:a:$$OBJCODE=PROJ 
EXISTS:a:programID=FIELD:ID 
EXISTS:a:status=CUR + ANY OTHER STATUSES THAT REPRESENT ACTIVE IN YOUR INSTANCE
EXISTS:a:status_Mod=in

Best Regards,

Rich

Avatar

Level 9

Great stuff, thanks, Rich!

This will also help me in understanding and learning EXISTS better, as I don't spend enough time using them.