<html dir="ltr">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=windows-1256">
<style id="owaParaStyle">P {
MARGIN-TOP: 0px; MARGIN-BOTTOM: 0px
}
</style>
</head>
<body fPStyle="1" ocsi="0">
<div style="direction: ltr;font-family: Tahoma;color: #000000;font-size: 10pt;">
<p>Hello, </p>
<p> </p>
<p>On the create ticket form I need to act upon a change to a drop down menu for a custom field (for this example 'Customer'), look up this value in a database table for a resulting default priority, and change the value in the priority drop down.</p>
<p> </p>
<p>Ordinarily this wouldn't be hard in a basic HTML form, creating a db connection manually, but I can't find where to start doing this within RT. I'm not sure where I should be putting my db query code. Does RT<a></a><a></a> allow me to put in a custom query
somewhere and handle the db connection? Would a scrip be suitable to do what I need?
</p>
<p> </p>
<p>I've searched the mailing list and tutorials but can't find a similar problem. Specific files to change and alternative ideas on how do this would be appreciated as I am new to RT.</p>
<p> </p>
<p>Regards,</p>
<p>Paul R</p>
</div>
<br clear=all> Think green - keep it on the screen.
This e-mail and any attachment is for authorised use by the intended recipient(s) only. It may contain proprietary material, confidential information and/or be subject to legal privilege. It should not be copied, disclosed to, retained or used by, any other party. If you are not an intended recipient then please promptly delete this e-mail and any attachment and all copies and inform the sender. Thank you.
</body>
</html>