Often we need to know the projects which has been saved by PM’s but hasn’t been published, in order to check with PM’s if they forgot to publish or intentionally they have saved the changes, all this is to make sure the correct data is reflected 🙂 , Make sure to run this against draft DB
Note: querying draft DB directly is not supported by MS, hence perform this at your own risk
So here is the query by which you can find out
select p.WPROJ_LAST_PUB, p.PROJ_LAST_SAVED, p.PROJ_NAME, p.Proj_UID from MSP_PROJECTS p where p.WPROJ_LAST_PUB < p.PROJ_LAST_SAVED
Leave a Reply