Project and Portfolio Management Practitioners Forum
cancel
Showing results for 
Search instead for 
Did you mean: 

transaction history for fields in a table component

Highlighted
Sascha Mohr
Esteemed Contributor

transaction history for fields in a table component

Is it possible to have a transaction history for fields in a table component in a request? We did not find such a feature but would like to track changes made to a list in a request. Do we have to implement an audit table for the kcrt_transactions table?
Regards
Sascha
4 REPLIES
Semenov Alexand
Esteemed Contributor

Re: transaction history for fields in a table component

Hi
It's possible only for table entities
Cris Robin
Regular Collector

Re: transaction history for fields in a table component

Hello Sascha

I've done something that is not perfect but my customer was happy enought with it.

i added a field with rnd value on line creation rule.
I added a text area field that collects the changes in the value field by an on change rule.

A user still can delete the all line.
I added the transaction history for the table component so it records the changes in number of lines.

Hope it help.

Sagi
Sascha Mohr
Esteemed Contributor

Re: transaction history for fields in a table component

Thanks Cris, that will probably solve the request. Seems like the next best thing to implementing database triggers.
Regards
Sascha
Cris Robin
Regular Collector

Re: transaction history for fields in a table component

Hello Sascha

I considered the database trigger but we voted against it because of HP support.

BTW, I forgot to say that the rnd number on the line is for comparison between the value in the database with the value in the line.

Hope it help

Sagi
//Add this to "OnDomLoad" event