M
Mike
I'm having a bit of trouble getting some reliable data from the Project
Server database and I'm hoping someone can point me in the right
direction. We have setup a Custom Project Outline Code to define a
project's status. I'm needing a solution that will record the
date/time when a PM sets a project's status to 'implemented' which, in
our system, is CODE_UID: 12. I understand that Enterprise Project
Dates are stored in the table MSP_DATE_FIELDS where DATE_CATEGORY = 0
AND DATE_REF_UID = 0. I have setup Enterprise Project Date 1 to be
this 'Implemented Date.' I have identified the CODE_FIELD_ID and the
DATE_FIELD_ID and written a trigger on the table MSP_CODE_FIELDS to
update this date field when the CODE_UID is changed to a 12. I've made
sure to set the bit flags PROJ_EXT_EDITED and PROJ_EXT_EDITED_DATE both
to a 1 within MSP_PROJECTS. Here's my confusion. If I manually change
these 2 bit fields back to 0, the date field as viewed from within
Project Pro > Project Information displays a date completely different
from the date that is stored in MSP_DATE_FIELDS. My question is where
is this other date being stored in the database? I can not find it
anywhere and I thought the MSP_DATE_FIELDS table was the only place
these were stored. Maybe a better question would be, is there a better
way to do this? An even better question would be, has anyone done this
before and what did you do?
Regards,
Mike
Server database and I'm hoping someone can point me in the right
direction. We have setup a Custom Project Outline Code to define a
project's status. I'm needing a solution that will record the
date/time when a PM sets a project's status to 'implemented' which, in
our system, is CODE_UID: 12. I understand that Enterprise Project
Dates are stored in the table MSP_DATE_FIELDS where DATE_CATEGORY = 0
AND DATE_REF_UID = 0. I have setup Enterprise Project Date 1 to be
this 'Implemented Date.' I have identified the CODE_FIELD_ID and the
DATE_FIELD_ID and written a trigger on the table MSP_CODE_FIELDS to
update this date field when the CODE_UID is changed to a 12. I've made
sure to set the bit flags PROJ_EXT_EDITED and PROJ_EXT_EDITED_DATE both
to a 1 within MSP_PROJECTS. Here's my confusion. If I manually change
these 2 bit fields back to 0, the date field as viewed from within
Project Pro > Project Information displays a date completely different
from the date that is stored in MSP_DATE_FIELDS. My question is where
is this other date being stored in the database? I can not find it
anywhere and I thought the MSP_DATE_FIELDS table was the only place
these were stored. Maybe a better question would be, is there a better
way to do this? An even better question would be, has anyone done this
before and what did you do?
Regards,
Mike