[rt-users] History of Custom Field Values kept anywhere?

Gene LeDuc gleduc at mail.sdsu.edu
Mon Aug 31 16:39:25 EDT 2009


Scott, look in the ObjectCustomFieldValues table.  There are pointers 
into it from the OldReference and NewReference fields in the 
Transactions table.  I'm using 3.6.3, but I'm guessing that the same 
will be true in 3.8.4.

Gene

Lander, Scott wrote:
>  
> We accidentally changed some values in a Custom Field, and they need to 
> be set back.    I can retrieve the values from our backup, but, the 
> question came up of if RT keeps the history for them.    Poking thru the 
> database, I see it keeps the history for tickets (table Transactions), 
> and that it keeps most of the data for Custom Fields in the table 
> CustomFieldValues.   It keeps Creator, Creation Date, Last Updated By 
> and Last Update Date.   But, so far, I haven't found anywhere it keeps 
> what was changed.      IE, category old value, new value, like you find 
> in the Transactions table.
>  
> This would seem to be very useful information to have - especially in 
> the case of a system audit.
>  
> Am I just missing something?
>  
> This in on RT 3.8.4, btw.




More information about the rt-users mailing list