Program Dashboard Sub-Project Open Issues – SQL

The Program Dashboard Sub-Project Open Issues portlet gives the ability to view issues on sub-projects of a program that are not closed or resolved. The portlet will pull the “id” from the page it is placed on, so this portlet is usually placed on the dashboard tab. The portlet sorts the issues first by priority and then by target date. It displays the sub-project name, issue name, owner, target date, status and priority.