Dashboard: Change Requests – SQL

The Dashboard:  Change Requests portlet gives an overview of all change requests on the project.  The portlet will pull the “id” from the page it is placed on, so this portlet is usually placed on the project dashboard tab.  The portlet sorts the issues first by priority and then by target date. It displays the name, owner, status, target date, approved by, and the priority.