Re: Search for full Case ID takes longer than just the number

2009-06-18 Thread Nichols, Wesley D CTR USAF AFMC 72 CS/SCBAF
I think you are falling into a QBE match issue. When you use just the number the system pre-pends the prefix onto the number and does an equal search. When you put in the entire number I bet it takes the default QBE for the field. You can verify this by looking at the SQL logs. Wes

Re: Search for full Case ID takes longer than just the number

2009-06-18 Thread Cecil, Ken
...@arslist.org] On Behalf Of Nichols, Wesley D CTR USAF AFMC 72 CS/SCBAF Sent: Thursday, June 18, 2009 10:26 AM To: arslist@ARSLIST.ORG Subject: Re: Search for full Case ID takes longer than just the number I think you are falling into a QBE match issue. When you use just the number the system pre

Re: Search for full Case ID takes longer than just the number

2009-06-18 Thread Carey Matthew Black
Ken, You need to look at all of these things: Server side logs: API, SQL, FILTER Client side logs: Active Links, Macros ( You know.. the whole ball of wax.) The flow basically (roughly off the top of my head) goes like this: Starting with the window already open in search mode with all