No, it did not. What "anywhere" did is as soon as i searched for record 70, it gave me 7070, 1070, 2070, 3070 and various other records.
thanks Chintan Kaiser Norm E CIV USAF 96 CS/SCCE <[EMAIL PROTECTED]> wrote: So setting the QBE behavior to "anywhere" didn't work? -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Chintan Shah Sent: Tuesday, March 18, 2008 4:26 PM To: arslist@ARSLIST.ORG Subject: Search on New fields on archived form ** Hi all, Once you archive the form, two new fields "Original Create Date" and "Original Request ID" are created. ...so far so good. Problem starts when end-users start searching on "Original Request ID" and get a no matching request back. That field is a Character Field. So, request ID 70 on Source Form is not same on Destination Form. I tried all QBE's. None of them work. It only works when you do a search on form like 'Original Request ID'="000000000000070". This is frustrating for end- users as they are not able to do search as they used to do previously. Any workarounds to make the new character field work like System field(DB ID:1)??? Thanks for your help in advance. Regards, Chintan ________________________________ Never miss a thing. Make Yahoo your homepage. __Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" html___ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" --------------------------------- Be a better friend, newshound, and know-it-all with Yahoo! Mobile. Try it now. _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"