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

[Ken Crocker]

Scott,

Try the Transaction Table.

Kenn
LBNL

On 8/31/2009 1:58 PM, Lander, Scott wrote:
> Ken,
>  
>    CustomFieldValues does have the current values, and documents when 
> they were inserted or modified, but, NOT the actual changes - IE, no 
> "Old Value / New Value".     For instance, for one of the lines in 
> question, the table has:
>  
> +-----+-------------+----------------------------------------------------------+-----------------------------+-----------+---------+---------------------+---------------+---------------------+
> | id  | CustomField | 
> Name                                                     | 
> Description                 | SortOrder | Creator | 
> Created             | LastUpdatedBy | LastUpdated         |
> +-----+-------------+----------------------------------------------------------+-----------------------------+-----------+---------+---------------------+---------------+---------------------+
> | 321 |          30 | 
> CPU                                                      
> |                             |         4 |     101 | 2009-08-05 
> 14:44:16 |           101 | 2009-08-24 19:56:54 |
>  
> What I need to find out is what the Name used to be!  It shouldn't be 
> CPU,  at one time (last week) it was something more like "NAS Storage".
>  
>  
>
>  
> Scott,
>
> That's because the ObjectCustomFieldValues Table is for changes to a 
> value for an OBJECT. To see the history for the Custom Fields 
> themselves, try CustomFieldValues.
>
>
> Kenn
> LBNL
>
> On 8/31/2009 1:45 PM, Lander, Scott wrote:
>> Gene,
>>
>> Thanks, but - as near as I can tell, ObjectCustomFieldValues has references from type RT::Ticket only.    IE, everything in it refers to a ticket change, not a global custom field change.
>>
>> Scott
>>
>>
>>
>>
>>   
>>>> 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.
>>>     
>>
>> ------------------------------------------------------------------------------------
>> This e-mail message is intended only for the personal use of the recipient(s) named above. If you are not an intended recipient, you may not review, copy or distribute this message. If you have received this communication in error, please notify the Hearst Service Center (cadmin at hearstsc.com) immediately by email and delete the original message.
>> ------------------------------------------------------------------------------------
>>
>> _______________________________________________
>> http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users
>>
>> Community help: http://wiki.bestpractical.com
>> Commercial support: sales at bestpractical.com
>>
>>
>> Discover RT's hidden secrets with RT Essentials from O'Reilly Media. 
>> Buy a copy at http://rtbook.bestpractical.com
>>
>>   
> ------------------------------------------------------------------------------------
> This e-mail message is intended only for the personal use of the recipient(s) named above. If you are not an intended recipient, you may not review, copy or distribute this message. If you have received this communication in error, please notify the Hearst Service Center (cadmin at hearstsc.com) immediately by email and delete the original message.
> ------------------------------------------------------------------------------------
>   
> ------------------------------------------------------------------------
>
> _______________________________________________
> http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users
>
> Community help: http://wiki.bestpractical.com
> Commercial support: sales at bestpractical.com
>
>
> Discover RT's hidden secrets with RT Essentials from O'Reilly Media. 
> Buy a copy at http://rtbook.bestpractical.com
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.bestpractical.com/pipermail/rt-users/attachments/20090831/e2e6cc3f/attachment.htm>