Summary:Is there a way that we can use a workflow action to determine if the project has been published? We tried looking at LastPublishedDate, but that field is non-blank (defaulted to created date) even if the project has not been published.
Product:Workflow for Project Server
There is no easy way to determine if the Project is published or not. When a project is first created it resides in the Draft Project Server database which is what necessitates the Draft option. In addition, the project will also be visible in the Reporting Project Server database but there is no indicator of whether the project is published. The cleanest way we can think of checking is to call the Project Server API, the PSI, and do a “ReadProject” web service call (http://msdn.microsoft.com/en-us/library/gg209668.aspx) . The method itself enables you to specify which data store, so if you did a lookup on the Published data store and it returned nothing, it's either in the draft or has been archived. A further check to the archive database will allow you to confidently know if the project is in the draft.