<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=Content-Type content="text/html; charset=iso-8859-1">
<META content="MSHTML 6.00.6000.16788" name=GENERATOR></HEAD>
<BODY>
<DIV dir=ltr align=left><SPAN class=035044109-24012009><FONT face=Arial
color=#0000ff size=2>Hi Calvin,</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=035044109-24012009><FONT face=Arial
color=#0000ff size=2>looking up the database is a possible, but ugly way i
think. Inside the RT Wiki you will find much better
solutions:</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=035044109-24012009><FONT face=Arial
color=#0000ff size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=035044109-24012009><FONT face=Arial
color=#0000ff size=2>Custom Action:</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=035044109-24012009><FONT face=Arial
color=#0000ff size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=035044109-24012009><FONT face=Arial
color=#0000ff size=2>Get Content from CF1: </FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=035044109-24012009><FONT face=Arial
color=#0000ff size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=035044109-24012009><FONT face=Arial
color=#0000ff size=2>my $cf1 =
$self->TicketObj->FirstCustomFieldValue('CF1Name');</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=035044109-24012009><FONT face=Arial
color=#0000ff size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=035044109-24012009><FONT face=Arial
color=#0000ff size=2>Then compare against something if
needed</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=035044109-24012009><FONT face=Arial
color=#0000ff size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=035044109-24012009><FONT face=Arial
color=#0000ff size=2>Write Content to CF2:</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=035044109-24012009><FONT face=Arial
color=#0000ff size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=035044109-24012009><FONT face=Arial
color=#0000ff size=2>$self->TicketObj->AddCustomFieldValue(Field =>
'CF2Name', Value => $cf1, RecordTransaction => 1); (or use 0 to not record
Transaction)</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=035044109-24012009><FONT face=Arial
color=#0000ff size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=035044109-24012009><FONT face=Arial
color=#0000ff size=2>Around this you need only a Custom Condition where you
check if CF Content has changed.</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=035044109-24012009><FONT face=Arial
color=#0000ff size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=035044109-24012009><FONT face=Arial
color=#0000ff size=2>It is much cleaner i think.,</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=035044109-24012009><FONT face=Arial
color=#0000ff size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=035044109-24012009><FONT face=Arial
color=#0000ff size=2>Torsten</FONT></SPAN></DIV><BR>
<br>
<p class=MsoBodyText><span style='font-size:8.0pt;font-family:Arial'>Kühne +
Nagel (AG & Co.) KG, Geschäftsleitung: Hans-Georg Brinkmann (Vors.), Uwe <span
class=SpellE>Bielang</span> (Stellv.), Dirk Blesius (Stellv.), Bruno Mang, Alfred <span
class=SpellE>Manke</span>, Christian Marnetté (Stellv.), Mark Reinhardt (Stellv.), Jens <span
class=SpellE>Wollesen</span>, Rainer <span class=SpellE>Wunn</span>,
Sitz: Bremen, Registergericht: Bremen, HRA 21928, <span class=SpellE>USt-IdNr</span>.:
DE 812773878, Persönlich haftende Gesellschaft: Kühne & Nagel A.G., Sitz: <span
class=SpellE>Contern/Luxemburg</span>, Geschäftsführender Verwaltungsrat:
Klaus-Michael Kühne <o:p></o:p></span></p>
<br><DIV class=OutlookMessageHeader lang=de dir=ltr align=left>
<HR tabIndex=-1>
<FONT face=Tahoma size=2><B>Von:</B> rt-users-bounces@lists.bestpractical.com
[mailto:rt-users-bounces@lists.bestpractical.com] <B>Im Auftrag von </B>Calvin
Gorriaran<BR><B>Gesendet:</B> Freitag, 23. Januar 2009 23:17<BR><B>An:</B>
rt-users@lists.bestpractical.com<BR><B>Betreff:</B> [rt-users] Custom field set
based on value of another customfield...<BR></FONT><BR></DIV>
<DIV></DIV>We are looking into ways to have a script update a custom field
(custom field 2) based on the value of another custom field (custom field 1).
This would hopefully be done by using a lookup table in the database to
determine the value of custom field 2 based on the value of custom field 1. Has
anyone done something like this in RT? We are currently running version
3.8.2.<BR><BR><BR>Thanks,<BR><BR>Cal<BR></BODY></HTML>