Dashboard: Open Milestones – SQL

The Dashboard: Open Milestones portlet gives an overview of all milestones that are started or not started for a single 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 milestones are sorted by Due Date. It displays the name, Due Date, Baseline Date, Days Late (Due Date – Baseline Date), and Days Old (Current Date – Due Date).