Projects that Should be Closed – Postgres

The Projects That Should Be Closed portlet displays all projects that have been created before the specified filter date and has had no new time, tasks, or risks/issues updated after the dates specified in the filter.  This can assist in identifying projects that are completed or cancelled and should be closed.

The table below describes the available columns in the portlet.

Column Label Description
Project Name Name of the project
PM Manager of the project
Created Date Created Date of the project
Start Start Date of the project
Finish Finish Date of the project
Created Date Check Identifies if the project meets the Created Before (Days) filter
Risks/Issues Check Identifies if the project meets the Risk/Issues – Days Back filter
Task Check Identifies if the project meets the Task – Days Back filter
Time Check Identifies if the project meets the Time – Days Back filter
Project Check Identifies if the project meets the portlet filter Criteria
id Internal code used by the query

 

 

Want access to our solutions?

Register for a free theBasiX™  account and upgrade to theWorX to gain access to all of the content available on RegoXchange™.

Download Details

RegoXchange Content ID: EX0100

Submission Date:

Submitter:

Content Type: Clarity Studio

Related Modules: Administrative Support

Company: Rego Consulting

Version Support

Versions Supported: 14.x, 15.x, 16.x

Special Instructions

Special Instructions: