I don't see where anybody mentioned it yet, but your database, O Mike, I don't see where anybody mentioned it yet, but your database, Oracle 9i, doesn't support bracket search notation. Brackets will always work in filter and active link run-if quals. However, when AR System needs to perform a database query, it has to depend on the underlying database's capabilities. Sybase and its distant cousin, SQL Server, understand bracketed LIKE statements, but Oracle does not.
Here's a quote from the Database Reference Guide: "Using Oracle with AR System ... For searches on database entries, the only wildcard characters supported in the LIKE comparison are the percent symbol (%) and the underscore (_). There is no support for sets or ranges of values. Wildcards are fully supported in filter, escalation, and active link qualifications and in pattern specifications for character fields." Tim Widowfield http://www.widowfield.com ----- Original Message ---- From: Mike White <[EMAIL PROTECTED]> To: arslist@ARSLIST.ORG Sent: Wednesday, October 11, 2006 2:32:47 PM Subject: Re: [ARSLIST] LIKE operator with brackets in search Thad, Thanks. I think you're onto something. Can't get it to work in a search - ASB or QBE. Tried Open Window AL action (Modify window) using this format and it didn't work, either. Tried it in a Set Fields If, but agin it didn't work. Then I tried your suggestion - using it in a Filter's Run If and it worked fine. Worked fine. Appropriately true (B or b) and appropriately false (neither B nor b). Odd. I'd carefully read the little available documentation (ARS 6 DAB p. 760), but it makes no distinction among search criteria, object Run If, Push Fields If or Set Fields If. Thanks for pointing me in the right direction. Mike White Office: 813-978-2192 E-mail: [EMAIL PROTECTED] "Thad Esser" <[EMAIL PROTECTED] To: arslist@ARSLIST.ORG COM> cc: Sent by: "Action Subject: Re: LIKE operator with brackets in search Request System discussion list(ARSList)" <[EMAIL PROTECTED] ORG> 10/11/2006 14:02 Please respond to arslist ** In the past, I've found that the brackets work in workflow (Active Links/Filters), but not in the Advanced search bar. Create a test filter that just puts up a message ("Run if true") and then play with the run if to get what you are looking for. Also, I think Remedy only uses a subset of possible regex expressions. Check out "wildcards" in the admin tool help (or the Basic guide) for the expressions that are supported. Thad "Argue for your limitations, and sure enough, they're yours."-- Richard Bach "Ray Gellenbeck" <[EMAIL PROTECTED]> Sent by: "Action Request System discussion list(ARSList)" <arslist@ARSLIST.ORG> To arslist@ARSLIST.ORG cc 10/11/2006 10:31 AM Subject Re: LIKE operator Please respond to with brackets in arslist@ARSLIST.ORG search ** Seperate the values with commas? [B,b] On 10/11/06, Mike White <[EMAIL PROTECTED]> wrote: No luck. I tried: 'Email Address' LIKE "[Bb]" (note Email Address, Field ID 103 is not indexed for FTS and QBE match set to Anywhere). The example you provided is how I understand its usage - brackets within the literal/quotes. I'm sure stumped getting it to work, though. Mike White Office: 813-978-2192 E-mail: [EMAIL PROTECTED] "David Sanders" <[EMAIL PROTECTED] To: arslist@ARSLIST.ORG TING.CO.UK> cc: Sent by: "Action Request Subject: Re: LIKE operator with brackets in search System discussion list(ARSList)" <arslist@ARSLIST.ORG> 10/11/2006 13:13 Please respond to arslist Hi Mike Here's an example of its usage in a run-if: 'zzTemp1' LIKE "[0-9]" Notice that you DO NOT need the wildcard operator. HTH David Sanders Remedy Solution Architect Enterprise Service Suite @ Work ========================== ARS List Award Winner 2005 Best 3rd party Remedy Application tel +44 1494 468980 mobile +44 7710 377761 email [EMAIL PROTECTED] web http://www.westoverconsulting.co.uk -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Mike White Sent: Wednesday, October 11, 2006 6:07 PM To: arslist@ARSLIST.ORG Subject: Re: LIKE operator with brackets in search Yes - I know I can expand the search with an OR to search for both conditions. I'm trying to understand how to use the brackets. It's an advertised feature. Is there a problem with it? I'm still researching on-line documentation... Mike White Office: 813-978-2192 E-mail: [EMAIL PROTECTED] "Grooms, Frederick W" To: arslist@ARSLIST.ORG <frederick.w.groo cc: [EMAIL PROTECTED]> Subject: Re: LIKE operator with brackets in search Sent by: "Action Request System discussion list(ARSList)" <[EMAIL PROTECTED] ORG> 10/11/2006 11:34 Please respond to arslist I think that is correct. Just to be safe why don't you just do the or in your search (and not worry about the brackets): (('Email Address' LIKE "B0%") OR ('Email Address' LIKE "b0%")) Fred -----Original Message----- From: Action Request System discussion list(ARSList) [mailto: [EMAIL PROTECTED] On Behalf Of Mike White Sent: Wednesday, October 11, 2006 10:12 AM To: arslist@ARSLIST.ORG Subject: LIKE operator with brackets in search Listers, I've never fiddled with searches that use a combination of LIKE operator and brackets (i.e. [ and ]). Have read the documentation and believe I'm using it correctly, but it's not returning any matching requests. My customer is changing their e-mail server and e-mail address format, so I'm trying to identify users whose e-mail address is in the old format. I'd previously implemented a maintenance facility so they can update their own, so I have a mix of upper and lower case entries. I'm looking for e-mail addresses that begin with B0 or b0, so in a User search window, I tried the following in ASB: 'Email Address' LIKE "[Bb]0%" If I use 'Email Address' LIKE "B0%" or 'Email Address' LIKE "b0%", each returns matching requests. Am I using this incorrectly (brackets or LIKE)? We're running ARS 6.0.1 , patch 1454, on Oracle 9i and Solaris 5.9 Mike White Office: 813-978-2192 E-mail: [EMAIL PROTECTED] ____________________________________________________________________________ ___ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org ____________________________________________________________________________ ___ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org -- Ray Gellenbeck [EMAIL PROTECTED] "Momma always says there's an awful lot you could tell about a person by their shoes. Where they're going. Where they've been. I've worn lots of shoes." -- Forrest Gump __20060125_______________________This posting was submitted with HTML in it___ ***IMPORTANT NOTICE: This communication, including any attachment, contains information that may be confidential or privileged, and is intended solely for the entity or individual to whom it is addressed. If you are not the intended recipient, you should delete this message and are hereby notified that any disclosure, copying, or distribution of this message is strictly prohibited. Nothing in this email, including any attachment, is intended to be a legally binding signature.*** __20060125_______________________This posting was submitted with HTML in it___ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org
