Retrieving "OldReference" values from Transaction

Can someone tell me how to retrieve the value that is referenced by
$self->TransactionObj->OldReference in a scrip? The actual value that
comes back is a reference to a record store in the ObjectCustomFieldValues
table of the database. I’ve tried about 20 different things trying to get
it to return the referenced value instead of the reference id, but so far
it’s beaten me. I’ve also looked at the wiki pretty thoroughly, but I
haven’t found anything there that does this. There’s plenty about
$self->TransactionObj->OldValue, but nothing about OldReference.

Thanks,
Gene

Gene LeDuc, GSEC
Security Analyst
San Diego State University

Don’t you hate it when you wish you’d waited a few minutes before hitting
the Send button?

Disregard my original request for help, I stumbled across the answer
myself. I was making things too complicated for myself by snooping in the
database. The RT code cleverly figures out whether it needs to undo a
reference or just return a value from the table when you grab
$self->TransactionObj->OldValue and returns whatever is appropriate. Very
nice!

Gene

At 01:45 PM 4/12/2007, Gene LeDuc wrote:

Can someone tell me how to retrieve the value that is referenced by
$self->TransactionObj->OldReference in a scrip? The actual value that
comes back is a reference to a record store in the ObjectCustomFieldValues
table of the database. I’ve tried about 20 different things trying to get
it to return the referenced value instead of the reference id, but so far
it’s beaten me. I’ve also looked at the wiki pretty thoroughly, but I
haven’t found anything there that does this. There’s plenty about
$self->TransactionObj->OldValue, but nothing about OldReference.

Thanks,
Gene


Gene LeDuc, GSEC
Security Analyst
San Diego State University


http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

Community help: http://wiki.bestpractical.com
Commercial support: sales@bestpractical.com

Discover RT’s hidden secrets with RT Essentials from O’Reilly Media. Buy a
copy at http://rtbook.bestpractical.com

Gene LeDuc, GSEC
Security Analyst
San Diego State University