Ken, I'm interresting for the code you've mentioned. Could you or somebody
else write me here that code or some similar, which will steal the
attachment from last comment and then I can use it in Resolve template, so
the Attachments which were put into ticket under Resolved phase will be
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
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
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
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,
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:
Except for Name,Type, Description, and Status; everything else in Asset
Tracker is a custom field. We need to make some fields global so that they
are always presented in search results like the default four, and so that
they are presented in the Query Builder without first having to select a
type
If I recall correctly, this is done the same way all other RT custom
fields are made global. Admin - Global - Custom Fields.
On Mon, Aug 31, 2009 at 5:03 PM, Michael
Ellismichael_el...@umanitoba.ca wrote:
Except for Name,Type, Description, and Status; everything else in Asset
Tracker is a
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
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
Thanks. I don't know how I missed that.
Can you think of a way to edit the default format so that it includes a CF
SerialNumber in every asset query result? I was looking in...
/opt/rt3/share/html/AssetTracker/Search/Results.html
and /opt/rt3/share/html/AssetTracker/Search/Build.html
...
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
Oh and it's the first thing, too. I'm sorry for not noticing that. I forget
than when you re-open something in vim it brings you to where you last were,
NOT the top of the file.
Apologies all,
Mike
-Original Message-
From: Todd Chapman [mailto:t...@chaka.net]
Sent: August-31-09 4:49
13 matches
Mail list logo