Project 2010 Admin - Field to query for task "Close Task to Updates" status

Question

Hi all,

Is there a field I can add to a view to display the status of the action "Close Task to Updates"?

I'd like to build a project view showing what tasks are still open/closed, but I don't see an obvious field. If there isn't a field in Project, maybe one in the Project Center or some other idea?

Thanks in advance for any guidance.

Answer 1

Hi there,

As far as I know (hopefully someone will correct me if I'm wrong!) there is no where to see this information other than on the Close Task to Updates page. This information isn't available in the reporting database either so you would need to access this data using the PSI, the field is: http://msdn.microsoft.com/en-us/library/websvcproject.projectdataset.taskrow.task_lockdown_by_manager_di_pj14mref.aspx

Hope that helps.

Paul

---

Paul Mather | Twitter | http://pwmather.wordpress.com | CPS

Answer 2

This field is not in the Reporting Database but it is in the Published Database:

dbo.MSP_TASKS.

TASK_LOCKDOWN_BY_MANAGER

ProjectServer_PWA_Published.