Eric, You would need to use an Active Link to perform this action. Actually you don't need to do anything though. On our Log Call form we have Ticket ID (field 1) set to equal for QBE match. When individuals enter the ticket number as 1495598 instead of TT01495598 and push the search button, the system automatically appends the prefix and the appropriate number of zeros. If I remember correctly this is an automatic function associated with field 1. Dave Dave Shellman
Phone: (717) 810-3687 Fax: (717) 810-2124 email: [EMAIL PROTECTED] tyco/Electronics A tyco International LTD Company MS 161-043 PO Box 3608 Harrisburg, PA 17105-3607 ________________________________ From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Eric Cleereman (IT) Sent: Thursday, December 21, 2006 4:32 PM To: arslist@ARSLIST.ORG Subject: Filter Phasing for Get Operations ** Hi All, I have a Request ID field users search on. Prior to the search being performed I'd like to change the value of the field. For instance, if a user searched for "164829", I'd like the search to actually look for "AST0000000164829". The field QBE on the field is set to EQUAL. If I set it to ANYWHERE, the search takes up to a minute, which is far longer than acceptable. I believe I need to use a Filter for this, as most of the time this search is performed from a hand scanner running Mobile Reach, which does not support Active Links. Using the SUBSTR and LENGTH functions, writing a Filter to substitute AST0000000164829 for 164829 is an easy enough task. The problem I am having is that the Filter fires after the search is performed, rather than before. The help file from the admin tool shows the following: Filter phasing for Get operations 1) Data is retrieved from the database 2) Filters run (including all Phase 1 and 3 actions) 3) Phase 2 actions occur As the error takes place prior to the search, the Filter processing is halted prior to taking place. Does anyone have a spiffy keen trick that would allow me to make the Filter fire prior to the search? Eric Cleereman __20060125_______________________This posting was submitted with HTML in it___ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"