Outline Code - Custom Field updates

J

JJ

I need to capture changes to the outline codes and custom fields and log the
old value and the new value to a separate table as an update happens.
Changes can come from multiple front-ends (i.e. Project, PWA, custom web
apps, etc.) so I would guess database triggers would be the logical place to
do this. I am fairly new to Project Server and I was wondering if anybody
with better PS expereince than me had any advice on this situation.
 
E

Ed Morrison

You are correct. A trigger is exactly what you need. Have a trigger on the
msp_outlinecodes table write to a history table.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Copy previous record into form field 0
Custom web part in PWA with custom fields for new project, 2
Project Server Custom Fields Update using PSI 0
PS7 - Custom Resource Field in Project Center 1
How to save project custom field value thru PSI 1
Custom PWA Field in My Timesheet Cannot Be Queried 1
Custom Project Outline Code no longer in Edit on PWA 0
How to Update Task Level Enterprise Custom Fields in PWA 1

Top