Locked Projects – SQL

The Locked Projects portlet displays all of the projects in the system that are currently in a ‘locked’ state.  The user may view the project ID, Project Name, Project Manager, the user who locked the project, the user’s email address, and the date the project was locked.

Administrators may utilize the data in this portlet in order to determine if a manual unlock should be executed on a project that has been locked for an extended period of time. Extended locks may indicate the individual has forgotten that he or she had obtained the lock. The portlet includes a hyperlink on the Project Name field, which will allow the administrator to more easily access and unlock the project as well as an email link to mail the user who locked the project.