<HTML>
<HEAD>
<TITLE>Re: [rt-users] History of Custom Field Values kept anywhere?</TITLE>
</HEAD>
<BODY>
<FONT SIZE="4"><FONT FACE="Calibri, Verdana, Helvetica, Arial"><SPAN STYLE='font-size:11pt'>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.<BR>
<BR>
I don’t know where this information could be kept, although I am seeing a History link for Users which logs password changes and information changes. Perhaps this could be extended for custom fields also?<BR>
<BR>
<BR>
On 8/31/09 6:48 PM, "Ken Crocker" <kfcrocker@lbl.gov> wrote:<BR>
<BR>
</SPAN></FONT></FONT><BLOCKQUOTE><FONT SIZE="4"><FONT FACE="Calibri, Verdana, Helvetica, Arial"><SPAN STYLE='font-size:11pt'>Scott,<BR>
<BR>
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.<BR>
<BR>
Kenn<BR>
LBNL<BR>
<BR>
On 8/31/2009 2:32 PM, Lander, Scott wrote: <BR>
</SPAN></FONT></FONT><BLOCKQUOTE><FONT SIZE="4"><FONT FACE="Calibri, Verdana, Helvetica, Arial"><SPAN STYLE='font-size:11pt'> <BR>
<BR>
<BR>
<BR>
</SPAN></FONT><SPAN STYLE='font-size:11pt'><FONT COLOR="#0000FF"><FONT FACE="Arial">Hi Ken,<BR>
</FONT></FONT><FONT FACE="Calibri, Verdana, Helvetica, Arial"> <BR>
<BR>
<BR>
</FONT><FONT COLOR="#0000FF"><FONT FACE="Arial"> 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 guess!!!<BR>
</FONT></FONT><FONT FACE="Calibri, Verdana, Helvetica, Arial"> <BR>
<BR>
<BR>
<BR>
<BR>
<BR>
<BR>
Scott,<BR>
<BR>
Try the Transaction Table.<BR>
<BR>
Kenn<BR>
LBNL<BR>
<BR>
On 8/31/2009 1:58 PM, Lander, Scott wrote: <BR>
</FONT></SPAN></FONT><BLOCKQUOTE><FONT SIZE="4"><SPAN STYLE='font-size:11pt'><FONT FACE="Calibri, Verdana, Helvetica, Arial"> <BR>
</FONT><FONT COLOR="#0000FF"><FONT FACE="Arial">Ken,<BR>
</FONT></FONT><FONT FACE="Calibri, Verdana, Helvetica, Arial"> <BR>
<BR>
<BR>
</FONT><FONT COLOR="#0000FF"><FONT FACE="Arial"> 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:<BR>
</FONT></FONT><FONT FACE="Calibri, Verdana, Helvetica, Arial"> <BR>
<BR>
<BR>
</FONT><FONT COLOR="#0000FF"><FONT FACE="Arial">+-----+-------------+----------------------------------------------------------+-----------------------------+-----------+---------+---------------------+---------------+---------------------+<BR>
| id | CustomField | Name | Description | SortOrder | Creator | Created | LastUpdatedBy | LastUpdated |<BR>
+-----+-------------+----------------------------------------------------------+-----------------------------+-----------+---------+---------------------+---------------+---------------------+<BR>
<BR>
</FONT></FONT><FONT FACE="Calibri, Verdana, Helvetica, Arial"> <BR>
</FONT><FONT COLOR="#0000FF"><FONT FACE="Arial">| 321 | 30 | CPU | | 4 | 101 | 2009-08-05 14:44:16 | 101 | 2009-08-24 19:56:54 | <BR>
</FONT></FONT><FONT FACE="Calibri, Verdana, Helvetica, Arial"> <BR>
<BR>
<BR>
</FONT><FONT COLOR="#0000FF"><FONT FACE="Arial">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".<BR>
</FONT></FONT><FONT FACE="Calibri, Verdana, Helvetica, Arial"> <BR>
<BR>
<BR>
<BR>
<BR>
<BR>
<BR>
<BR>
<BR>
Scott,<BR>
<BR>
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.<BR>
<BR>
<BR>
Kenn<BR>
LBNL<BR>
<BR>
On 8/31/2009 1:45 PM, Lander, Scott wrote: <BR>
</FONT></SPAN></FONT><BLOCKQUOTE><FONT SIZE="4"><SPAN STYLE='font-size:11pt'><FONT FACE="Calibri, Verdana, Helvetica, Arial"> <BR>
Gene,<BR>
<BR>
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.<BR>
<BR>
Scott<BR>
<BR>
<BR>
<BR>
<BR>
<BR>
<BR>
</FONT></SPAN></FONT><BLOCKQUOTE><FONT SIZE="4"><SPAN STYLE='font-size:11pt'><FONT FACE="Calibri, Verdana, Helvetica, Arial"> <BR>
</FONT></SPAN></FONT><BLOCKQUOTE><FONT SIZE="4"><SPAN STYLE='font-size:11pt'><FONT FACE="Calibri, Verdana, Helvetica, Arial"> <BR>
Scott, look in the ObjectCustomFieldValues table. There are pointers into it from the OldReference and NewReference<BR>
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.<BR>
<BR>
Gene<BR>
<BR>
<BR>
</FONT></SPAN></FONT></BLOCKQUOTE><FONT SIZE="4"><SPAN STYLE='font-size:11pt'><FONT FACE="Calibri, Verdana, Helvetica, Arial"> <BR>
</FONT></SPAN></FONT></BLOCKQUOTE><FONT SIZE="4"><SPAN STYLE='font-size:11pt'><FONT FACE="Calibri, Verdana, Helvetica, Arial"> <BR>
<BR>
Lander, Scott wrote:<BR>
<BR>
<BR>
</FONT></SPAN></FONT><BLOCKQUOTE><FONT SIZE="4"><SPAN STYLE='font-size:11pt'><FONT FACE="Calibri, Verdana, Helvetica, Arial"> <BR>
We accidentally changed some values in a Custom Field, and they need to<BR>
be set back. I can retrieve the values from our backup, but, the<BR>
question came up of if RT keeps the history for them. Poking thru the<BR>
database, I see it keeps the history for tickets (table Transactions),<BR>
and that it keeps most of the data for Custom Fields in the table<BR>
CustomFieldValues. It keeps Creator, Creation Date, Last Updated By<BR>
and Last Update Date. But, so far, I haven't found anywhere it keeps<BR>
what was changed. IE, category old value, new value, like you find<BR>
in the Transactions table.<BR>
<BR>
This would seem to be very useful information to have - especially in<BR>
the case of a system audit.<BR>
<BR>
Am I just missing something?<BR>
<BR>
This in on RT 3.8.4, btw.<BR>
<BR>
<BR>
</FONT></SPAN></FONT></BLOCKQUOTE><FONT SIZE="4"><SPAN STYLE='font-size:11pt'><FONT FACE="Calibri, Verdana, Helvetica, Arial"> <BR>
<BR>
------------------------------------------------------------------------------------<BR>
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@hearstsc.com) immediately by email and delete the original message.<BR>
------------------------------------------------------------------------------------<BR>
<BR>
_______________________________________________<BR>
<a href="http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users">http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users</a><BR>
<BR>
Community help: <a href="http://wiki.bestpractical.com">http://wiki.bestpractical.com</a><BR>
Commercial support: sales@bestpractical.com<BR>
<BR>
<BR>
Discover RT's hidden secrets with RT Essentials from O'Reilly Media. <BR>
Buy a copy at <a href="http://rtbook.bestpractical.com">http://rtbook.bestpractical.com</a><BR>
<BR>
<BR>
<BR>
<BR>
------------------------------------------------------------------------------------<BR>
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@hearstsc.com) immediately by email and delete the original message.<BR>
------------------------------------------------------------------------------------<BR>
<BR>
<BR>
<HR ALIGN=CENTER SIZE="4" WIDTH="90%"><BR>
_______________________________________________<BR>
<a href="http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users">http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users</a><BR>
<BR>
Community help: <a href="http://wiki.bestpractical.com">http://wiki.bestpractical.com</a><BR>
Commercial support: sales@bestpractical.com<BR>
<BR>
<BR>
Discover RT's hidden secrets with RT Essentials from O'Reilly Media. <BR>
Buy a copy at <a href="http://rtbook.bestpractical.com">http://rtbook.bestpractical.com</a><BR>
<BR>
<BR>
------------------------------------------------------------------------------------<BR>
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@hearstsc.com) immediately by email and delete the original message.<BR>
------------------------------------------------------------------------------------<BR>
<BR>
<BR>
<BR>
<HR ALIGN=CENTER SIZE="4" WIDTH="90%"><BR>
_______________________________________________<BR>
<a href="http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users">http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users</a><BR>
<BR>
Community help: <a href="http://wiki.bestpractical.com">http://wiki.bestpractical.com</a><BR>
Commercial support: sales@bestpractical.com<BR>
<BR>
<BR>
Discover RT's hidden secrets with RT Essentials from O'Reilly Media. <BR>
Buy a copy at <a href="http://rtbook.bestpractical.com">http://rtbook.bestpractical.com</a><BR>
<BR>
<HR ALIGN=CENTER SIZE="3" WIDTH="95%"></FONT></SPAN></FONT></BLOCKQUOTE></BLOCKQUOTE></BLOCKQUOTE><FONT SIZE="4"><FONT FACE="Consolas, Courier New, Courier"><SPAN STYLE='font-size:10pt'>_______________________________________________<BR>
<a href="http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users">http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users</a><BR>
<BR>
Community help: <a href="http://wiki.bestpractical.com">http://wiki.bestpractical.com</a><BR>
Commercial support: sales@bestpractical.com<BR>
<BR>
<BR>
Discover RT's hidden secrets with RT Essentials from O'Reilly Media. <BR>
Buy a copy at <a href="http://rtbook.bestpractical.com">http://rtbook.bestpractical.com</a><BR>
</SPAN></FONT></FONT></BLOCKQUOTE><FONT SIZE="4"><FONT FACE="Consolas, Courier New, Courier"><SPAN STYLE='font-size:10pt'><BR>
</SPAN></FONT><FONT FACE="Calibri, Verdana, Helvetica, Arial"><SPAN STYLE='font-size:11pt'>-- <BR>
Drew Barnes<BR>
Applications Analyst<BR>
Network Resources Dept.<BR>
Raymond Walters College<BR>
</SPAN></FONT></FONT>
</BODY>
</HTML>