Re: Search on New fields on archived form

2008-03-19 Thread Chintan Shah
Thanks Carey. I will try to do it using Active Link. Regards, Chintan. Carey Matthew Black <[EMAIL PROTECTED]> wrote: The reason for this is that ARS does some funny (strange) things with searches on field 1. Specifically I have never seen the full logic spelled out in the docs, but here is wh

Re: Search on New fields on archived form

2008-03-19 Thread Carey Matthew Black
The reason for this is that ARS does some funny (strange) things with searches on field 1. Specifically I have never seen the full logic spelled out in the docs, but here is what I think it does if (User input length is less than length of field 1) then LPad the value with the prefix for f

Re: Search on New fields on archived form

2008-03-18 Thread Chintan Shah
;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 fi

Re: Search on New fields on archived form

2008-03-18 Thread Kaiser Norm E CIV USAF 96 CS/SCCE
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 o

Search on New fields on archived form

2008-03-18 Thread Chintan Shah
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 S