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. <http://us.rd.yahoo.com/evt=51438/*http://www.yahoo.com/r/hs> __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"
