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

I think the issue is a matter of understanding. From reading his messages I get the impression that someone has, in the UI, changed the Name of the custom field. I don¹t know where this information could be kept, although I am seeing a History link for Users which logs password changes and

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

Drew, You are correct. I am not (at this time) interested in the change of the value of a custom field within a ticket.It is the name of the field, as changed from the configuration menu of the UI, that I am interested in tracking.And, as you point out, there are history links for

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

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

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

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

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

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

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

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,

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

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:

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

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

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

Hi Ken, Transaction table was my first guess - but, nope - looks like everything BUT the Custom Fields is kept there! Right now, I am thinking that for some reason this data is just not kept - which sort of surprises me! Oh well - time for a bug report or wish list submission, I

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

Scott, That can't be. I use the transaction record to trigger several scrips that look at the changes in a CF. Try transactions with Type = CustomField, Field = the number of the CF and old/new values. Kenn LBNL On 8/31/2009 2:32 PM, Lander, Scott wrote: Hi Ken, Transaction table