Projects and Task Hierarchy – SQL

Grid Portlet displays project and task data–including name, dates, status, effort, %Complete, and schedule.  Portlet initially displays project data.  But there is a + sign toggle, which, when clicked, reveals task data, and the toggle becomes a – sign.  User can choose to Automatically Expand all levels from Options Icon>Configure>List Column Section>Options.  Portlet supports up to 10 levels of WBS.  Portlet filterable by project name and ID, OBS structure, manager name, active/inactive, and open for time entry.