Hi,
One more thing about QBE and the Request ID field (Field id 1).
You can indeed just type ('Record Number' = 1234), and this will actually
result in the following search to the database ('Record Number' =
"PREFIX00001234").
So if the actual prefix of your specific record matches the current prefix
defined for the form, you should get a match.
Kathy, it seems that you mistyped something, as you talk about both 1425,
REC1425 and INC1425 at the same time. The minimum length of the number-part is
5 digits. But maybe the field you are talking about is not field id 1...
I use this kind of search very often: '1' = 1234
Best Regards - Misi, RRR AB, http://www.rrr.se (ARSList MVP 2011)
Ask the Remedy Licensing Experts (Best R.O.I. Award at WWRUG10/11/12/13):
* RRR|License - Not enough Remedy licenses? Save money by optimizing.
* RRR|Log - Performance issues or elusive bugs? Analyze your Remedy logs.
Find these products, and many free tools and utilities, at http://rrr.se.
> Kathy,
>
> It was not clear from your last message whether you had the answer you needed.
>
> I will expand on LJ's comments.
>
> QBE Anywhere applies to the QBE section of the screen. That is the field
> layout section or the "Query by
> Example" area. The Advanced Search bar is exactly that an advanced ADDITIONAL
> search to any criteria
> specified in the QBE area. There are no options or qualifications there. You
> must enter exactly what you
> want to do in the Advanced search bar.
>
> If you want to find something with a partial match, you must use the LIKE
> operator (that is done for you
> automatically in the QBE section).
>
> So, your search would be
>
> 'Record Number' LIKE "%1234"
>
> The LIKE operator indicates you are doing a pattern match vs. an = which is an
> exact match. When using LIKE,
> you use wildcard characters to specify the pattern you want.
>
> 'a' LIKE "1234"
> no wildcards so it is equivalent to 'a' = "1234"
>
> 'a' LIKE "%1234"
> wildcard of % means match any 0 or more characters so anything ENDING in
> 1234 would be found
>
> 'a' LIKE "%1234%"
> wildcard of % at start and end means match anything having 1234 anywhere
> in the value
>
> You need to use the right syntax in the Advanced query bar to accomplish what
> you are looking for.
>
>
> Now, if you have QBE set to Anywhere, you could have just put 1234 in the
> Record Number field up in the
> screen area and it would have found the right match for you.
>
> I hope this helps,
>
> Doug Mueller
>
> From: Action Request System discussion list(ARSList)
> [mailto:arslist@ARSLIST.ORG] On Behalf Of Kathy Morris
> Sent: Wednesday, September 10, 2014 8:36 AM
> To: arslist@ARSLIST.ORG
> Subject: Search
>
> **
> Hi,
>
> There is record in the Form A REC1425.
> When I Advanced Search in the form :
>
> 'Record Number = 1425 (this does not work)
> 'Record Number = INC1425 (this works, the record appears).
>
> The field is set to QBE=Anywhere.
>
>
> _ARSlist: "Where the Answers Are" and have been for 20 years_
>
> _______________________________________________________________________________
> UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
> "Where the Answers Are, and have been for 20 years"
>
_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
"Where the Answers Are, and have been for 20 years"
