My Tasks "Notes" field - which database view or table / column?

[anovak]

Where might I find the Notes field entered by resources in the My Task
screen, relative to a particular assignment in either the draft or
reporting database (view or table & column)? Is it possible to
produce a report (say, using SQL Reporting Services) that outputs the
notes by resource, date, task, and project?

Thanks,
Andy Novak
University of North Texas

 

[jleifb]

Hello Andy,

I came across this link because I had the same question. It appears to be
in the Published DB, under the [dbo].[MSP_TASKS] under the TASK_RTF_NOTES
field. The following link explains.
http://blogs.msdn.com/chrisfie/arch...t-project-task-s-notes-field-in-a-report.aspx

Hope this helps.

Thanks,
Josh