<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns="http://www.w3.org/TR/REC-html40"><head><meta http-equiv=Content-Type content="text/html; charset=us-ascii"><meta name=Generator content="Microsoft Word 12 (filtered medium)"><!--[if !mso]><style>v\:* {behavior:url(#default#VML);}
o\:* {behavior:url(#default#VML);}
w\:* {behavior:url(#default#VML);}
.shape {behavior:url(#default#VML);}
</style><![endif]--><style><!--
/* Font Definitions */
@font-face
{font-family:"Cambria Math";
panose-1:2 4 5 3 5 4 6 3 2 4;}
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
@font-face
{font-family:Tahoma;
panose-1:2 11 6 4 3 5 4 4 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0cm;
margin-bottom:.0001pt;
font-size:11.0pt;
font-family:"Calibri","sans-serif";}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:purple;
text-decoration:underline;}
p.MsoAcetate, li.MsoAcetate, div.MsoAcetate
{mso-style-priority:99;
mso-style-link:"Balloon Text Char";
margin:0cm;
margin-bottom:.0001pt;
font-size:8.0pt;
font-family:"Tahoma","sans-serif";}
p.MsoListParagraph, li.MsoListParagraph, div.MsoListParagraph
{mso-style-priority:34;
margin-top:0cm;
margin-right:0cm;
margin-bottom:0cm;
margin-left:36.0pt;
margin-bottom:.0001pt;
font-size:11.0pt;
font-family:"Calibri","sans-serif";}
span.EmailStyle17
{mso-style-type:personal-compose;
font-family:"Calibri","sans-serif";
color:windowtext;}
span.BalloonTextChar
{mso-style-name:"Balloon Text Char";
mso-style-priority:99;
mso-style-link:"Balloon Text";
font-family:"Tahoma","sans-serif";}
.MsoChpDefault
{mso-style-type:export-only;}
@page WordSection1
{size:612.0pt 792.0pt;
margin:72.0pt 72.0pt 72.0pt 72.0pt;}
div.WordSection1
{page:WordSection1;}
/* List Definitions */
@list l0
{mso-list-id:1378357852;
mso-list-type:hybrid;
mso-list-template-ids:-1374910442 201916439 201916441 201916443 201916431 201916441 201916443 201916431 201916441 201916443;}
@list l0:level1
{mso-level-number-format:alpha-lower;
mso-level-text:"%1\)";
mso-level-tab-stop:none;
mso-level-number-position:left;
text-indent:-18.0pt;}
@list l0:level2
{mso-level-number-format:alpha-lower;
mso-level-tab-stop:none;
mso-level-number-position:left;
text-indent:-18.0pt;}
ol
{margin-bottom:0cm;}
ul
{margin-bottom:0cm;}
--></style><!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="2050" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]--></head><body lang=EN-AU link=blue vlink=purple><div class=WordSection1><p class=MsoNormal>Hi All,<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>New RT user here (v4.01), firstly thanks for such a complete open source product, very impressed and grateful.<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>I’ve done some RTFM/RTFW and seen how to set one custom field based on the entry of another however, I have want a many to one relationship to exist between the orginal custom field (call it CF1) and the one I wish to auto set (call it CF2).<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>I’m guessing I could manually handle the one to many, by making a perl (dictionary/pair??) array (sorry if terminology is hopeless, no recent perl experience either). And then set CF2 based on this lookup. But I would prefer to be able to <o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoListParagraph style='text-indent:-18.0pt;mso-list:l0 level1 lfo1'><![if !supportLists]><span style='mso-list:Ignore'>a)<span style='font:7.0pt "Times New Roman"'> </span></span><![endif]>Create a lookup table in RT and give queue admins the right to CRUD it<o:p></o:p></p><p class=MsoListParagraph style='margin-left:72.0pt;text-indent:-18.0pt;mso-list:l0 level2 lfo1'><![if !supportLists]><span style='mso-list:Ignore'>a.<span style='font:7.0pt "Times New Roman"'> </span></span><![endif]>Is there a mechanism/extension in RT4 to do this?<o:p></o:p></p><p class=MsoListParagraph style='text-indent:-18.0pt;mso-list:l0 level1 lfo1'><![if !supportLists]><span style='mso-list:Ignore'>b)<span style='font:7.0pt "Times New Roman"'> </span></span><![endif]>Is there also a mechanism of external lookup tables to be queried in the RT schema without kludging in some manual DBI:: into the scrip.<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>Or is there a better way entirely??<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>To set the scene, I’m after a user being able to set the newspaper masthead they work for via a populated dropdown custom field, many mastheads may map to one database, and one terminal server so something like<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>Masthead,Database<o:p></o:p></p><p class=MsoNormal>Border Mail, RegionalDB<o:p></o:p></p><p class=MsoNormal>Ballarat Courier, REgionalDB<o:p></o:p></p><p class=MsoNormal>SMH, MetroDB<o:p></o:p></p><p class=MsoNormal>TheAge, MetroDB<o:p></o:p></p><p class=MsoNormal>Mercury, MetroDB<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>CF1 would be where you select the masthead, CF2 would result in showing the associated Database.<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>Note that there could be hundreds, and they may change regularly hence the desire to provide some sort of CRUD interface rather than hand coding it within a Scrip.<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>Any suggestions/pointers would be gratefully received.<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>Thanks in advance,<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>Roger.<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal><b><span style='font-size:8.0pt;font-family:"Arial","sans-serif";color:gray'>--</span></b><span style='font-size:11.5pt;color:black'> </span><span style='font-size:11.5pt;color:black'><br></span><b><span style='font-size:8.0pt;font-family:"Arial","sans-serif";color:gray'>Roger Lockerbie</span></b><span style='font-size:11.5pt;color:black'> </span><span style='font-size:11.5pt;color:black'><br></span><span style='font-size:8.0pt;font-family:"Arial","sans-serif";color:gray'>IT Special Projects Manager </span><span style='font-size:11.5pt;color:black'><br></span><span style='font-size:8.0pt;font-family:"Arial","sans-serif";color:gray'>Fairfax Media </span><span style='font-size:11.5pt;color:black'><br></span><b><span style='font-size:8.0pt;font-family:"Arial","sans-serif";color:gray'>--</span></b><span style='font-size:11.5pt;color:black'> </span><span style='font-size:11.5pt;color:black'><br></span><span style='font-size:8.0pt;font-family:"Arial","sans-serif";color:gray'>1 McKoy St, Wodonga VIC 3690 </span><span style='font-size:11.5pt;color:black'><br></span><b><span style='font-size:8.0pt;font-family:"Arial","sans-serif";color:gray'>T</span></b><span style='font-size:8.0pt;font-family:"Arial","sans-serif";color:gray'> 02 6024 0677 | <b>M</b> 0419 224 383 | <b>F</b> 02 6024 0606 </span><span style='font-size:11.5pt;color:black'><br></span><span style='font-size:8.0pt;font-family:"Arial","sans-serif";color:gray'><a href="mailto:rlockerbie@fairfaxmedia.com.au"><span style='color:blue'>rlockerbie@fairfaxmedia.com.au</span></a> | <a href="http://www.theage.com.au/"><span style='color:blue'>www.fairfaxmedia.com.au</span></a> </span><span style='font-size:11.5pt;color:black'><br><br><img border=0 width=160 height=101 id="Picture_x0020_1" src="cid:image001.png@01CC42E7.F0EA0950" alt="cid:0C5A3A47-BFCB-4E11-9223-65194BE76476"></span><span style='font-size:10.5pt;color:black'><o:p></o:p></span></p><p class=MsoNormal><o:p> </o:p></p></div><p></p><p></p><p></p><p><br><br><br>
<hr size=2 width="100%" align=center tabindex=-1>
<font face=Arial size=1>The information contained in this e-mail message and any accompanying files is or may be confidential. If you are not the intended recipient, any use, dissemination, reliance, forwarding, printing or copying of this e-mail or any attached files is unauthorised. This e-mail is subject to copyright. No part of it should be reproduced, adapted or communicated without the written consent of the copyright owner. If you have received this e-mail in error please advise the sender immediately by return e-mail or telephone and delete all copies. Fairfax does not guarantee the accuracy or completeness of any information contained in this e-mail or attached files. Internet communications are not secure, therefore Fairfax does not accept legal responsibility for the contents of this message or attached files.</font>
<hr size=2 width="100%" align=center tabindex=-1>
</body></html>