Late Issues – SQL

The Late Issues portlet displays all issues related to active projects that the logged in user has view rights to.  The issues displayed are those that are past their target resolution date but not Closed or Resolved.   The portlet provides a Project Manager the ability to view and track issues across multiple projects without going into each project individually.

This portlet displays the issue, the associated project name and project manager, as well as the issue owner, target resolution date, status, and priority of the issue, along with the total number of days the issue has been open. The user has the ability to filter by several criteria in order to narrow down the late issues.