<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=us-ascii">
<META NAME="Generator" CONTENT="MS Exchange Server version 08.00.0681.000">
<TITLE>dynamic search of custom field</TITLE>
</HEAD>
<BODY>
<!-- Converted from text/rtf format -->
<P DIR=LTR><SPAN LANG="en-us"><FONT COLOR="#17365D" FACE="Calibri">I have installed version 4.2.10</FONT></SPAN><SPAN LANG="en-us"><FONT COLOR="#17365D" FACE="Calibri">.</FONT></SPAN><SPAN LANG="en-us"></SPAN></P>
<P DIR=LTR><SPAN LANG="en-us"><FONT COLOR="#17365D" FACE="Calibri">I</FONT></SPAN><SPAN LANG="en-us"> <FONT COLOR="#17365D" FACE="Calibri">imported and</FONT></SPAN><SPAN LANG="en-us"> <FONT COLOR="#17365D" FACE="Calibri">updated the</FONT></SPAN><SPAN LANG="en-us"> <FONT COLOR="#17365D" FACE="Calibri">older (version 3.8.4) RT database.</FONT></SPAN><SPAN LANG="en-us"></SPAN></P>
<P DIR=LTR><SPAN LANG="en-us"><FONT COLOR="#17365D" FACE="Calibri">So far all seems to be working fine.</FONT></SPAN><SPAN LANG="en-us"></SPAN></P>
<P DIR=LTR><SPAN LANG="en-us"><FONT COLOR="#17365D" FACE="Calibri">I have</FONT></SPAN><SPAN LANG="en-us"> <FONT COLOR="#17365D" FACE="Calibri">a</FONT></SPAN><SPAN LANG="en-us"><FONT COLOR="#17365D" FACE="Calibri"> custom field on my Ticket/Create.</FONT></SPAN><SPAN LANG="en-us"><FONT COLOR="#17365D" FACE="Calibri">html</FONT></SPAN><SPAN LANG="en-us"><FONT COLOR="#17365D" FACE="Calibri"> page</FONT></SPAN><SPAN LANG="en-us"><FONT COLOR="#17365D" FACE="Calibri"> (Customer</FONT></SPAN><SPAN LANG="en-us"><FONT COLOR="#17365D" FACE="Calibri">s</FONT></SPAN><SPAN LANG="en-us"><FONT COLOR="#17365D" FACE="Calibri">) which</FONT></SPAN><SPAN LANG="en-us"> <FONT COLOR="#17365D" FACE="Calibri">is a</FONT></SPAN><SPAN LANG="en-us"><FONT COLOR="#17365D" FACE="Calibri"></FONT></SPAN><SPAN LANG="en-us"> <FONT COLOR="#17365D" FACE="Calibri">‘</FONT></SPAN><SPAN LANG="en-us"><FONT COLOR="#17365D" FACE="Calibri">Select one value</FONT></SPAN><SPAN LANG="en-us"><FONT COLOR="#17365D" FACE="Calibri">’</FONT></SPAN><SPAN LANG="en-us"><FONT COLOR="#17365D" FACE="Calibri"> Select box</FONT></SPAN><SPAN LANG="en-us"><FONT COLOR="#17365D" FACE="Calibri">,</FONT></SPAN><SPAN LANG="en-us"> <FONT COLOR="#17365D" FACE="Calibri">is loaded using</FONT></SPAN><SPAN LANG="en-us"> <FONT COLOR="#17365D" FACE="Calibri">a package (RT::CustomFieldValues::Customers) located in rt4/local/lib/RT/CustomFieldValues</FONT></SPAN><SPAN LANG="en-us"><FONT COLOR="#17365D" FACE="Calibri"> and contains a very large number of customers</FONT></SPAN><SPAN LANG="en-us"><FONT COLOR="#17365D" FACE="Calibri">.</FONT></SPAN></P>
<P DIR=LTR><SPAN LANG="en-us"></SPAN></P>
<P DIR=LTR><SPAN LANG="en-us"><FONT COLOR="#17365D" FACE="Calibri">I</FONT></SPAN><SPAN LANG="en-us"> <FONT COLOR="#17365D" FACE="Calibri">have added a text box above this select box (named</FONT></SPAN><SPAN LANG="en-us"> <FONT COLOR="#17365D" FACE="Calibri">‘</FONT></SPAN><SPAN LANG="en-us"><FONT COLOR="#17365D" FACE="Calibri">Search Customers</FONT></SPAN><SPAN LANG="en-us"><FONT COLOR="#17365D" FACE="Calibri">’</FONT></SPAN><SPAN LANG="en-us"><FONT COLOR="#17365D" FACE="Calibri">) and would like to modify the contents of</FONT></SPAN><SPAN LANG="en-us"><FONT COLOR="#17365D" FACE="Calibri"> the select box each time the</FONT></SPAN><SPAN LANG="en-us"> <FONT COLOR="#17365D" FACE="Calibri">“</FONT></SPAN><SPAN LANG="en-us"><FONT COLOR="#17365D" FACE="Calibri">keyup</FONT></SPAN><SPAN LANG="en-us"><FONT COLOR="#17365D" FACE="Calibri">”</FONT></SPAN><SPAN LANG="en-us"><FONT COLOR="#17365D" FACE="Calibri"> event is fired for this text box; and base the query which loads the select box with a where clause similar to</FONT></SPAN><SPAN LANG="en-us"> <FONT COLOR="#17365D" FACE="Calibri">“</FONT></SPAN><SPAN LANG="en-us"><FONT COLOR="#17365D" FACE="Calibri">where customer_name like</FONT></SPAN><SPAN LANG="en-us"> <FONT COLOR="#17365D" FACE="Calibri">‘</FONT></SPAN><SPAN LANG="en-us"><FONT COLOR="#17365D" FACE="Calibri">%<text field content>%</FONT></SPAN><SPAN LANG="en-us"><FONT COLOR="#17365D" FACE="Calibri">’</FONT></SPAN><SPAN LANG="en-us"><FONT COLOR="#17365D" FACE="Calibri">.</FONT></SPAN></P>
<P DIR=LTR><SPAN LANG="en-us"><FONT COLOR="#17365D" FACE="Calibri">I just can</FONT></SPAN><SPAN LANG="en-us"><FONT COLOR="#17365D" FACE="Calibri">’</FONT></SPAN><SPAN LANG="en-us"><FONT COLOR="#17365D" FACE="Calibri">t find out what I need to do to </FONT></SPAN></P>
<P DIR=LTR><SPAN LANG="en-us"><FONT COLOR="#17365D" FACE="Calibri">1) </FONT></SPAN><SPAN LANG="en-us"></SPAN><SPAN LANG="en-us"></SPAN><SPAN LANG="en-us"></SPAN><SPAN LANG="en-us"> <FONT COLOR="#17365D" FACE="Calibri">reload the Ticket/Create page on the</FONT></SPAN><SPAN LANG="en-us"> <FONT COLOR="#17365D" FACE="Calibri">‘</FONT></SPAN><SPAN LANG="en-us"><FONT COLOR="#17365D" FACE="Calibri">Select Customers</FONT></SPAN><SPAN LANG="en-us"><FONT COLOR="#17365D" FACE="Calibri">’</FONT></SPAN><SPAN LANG="en-us"><FONT COLOR="#17365D" FACE="Calibri"> keyup event; and</FONT></SPAN></P>
<P DIR=LTR><SPAN LANG="en-us"><FONT COLOR="#17365D" FACE="Calibri">2) </FONT></SPAN><SPAN LANG="en-us"> <FONT COLOR="#17365D" FACE="Calibri">pass the text box content (value) to the query</FONT></SPAN><SPAN LANG="en-us"> <FONT COLOR="#17365D" FACE="Calibri">in RT::CustomFieldValues::Customers.</FONT></SPAN></P>
<P DIR=LTR><SPAN LANG="en-us"></SPAN><SPAN LANG="en-us"></SPAN></P>
<P DIR=LTR><SPAN LANG="en-us"><FONT COLOR="#17365D" FACE="Calibri">Any assistance with this would be greatly appreciated.</FONT></SPAN></P>
<P DIR=LTR><SPAN LANG="en-us"><FONT COLOR="#17365D" FACE="Calibri">Thanks,</FONT></SPAN><SPAN LANG="en-us"></SPAN></P>
<P DIR=LTR><SPAN LANG="en-us"></SPAN></P>
<P DIR=LTR><SPAN LANG="en-us"><FONT COLOR="#17365D" FACE="Calibri">Mike</FONT></SPAN><SPAN LANG="en-us"><I></I></SPAN><SPAN LANG="en-us"><I></I></SPAN><I><SPAN LANG="en-us"></SPAN></I></P>
<P DIR=LTR ALIGN=CENTER><SPAN LANG="en-us"></SPAN><SPAN LANG="en-us"></SPAN></P>
<P DIR=LTR><SPAN LANG="en-us"></SPAN></P>
</BODY>
</HTML>