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)" <[email protected]> 10/11/2006 10:31 AM
|
|
** 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: [email protected]
TING.CO.UK> cc:
Sent by: "Action Request Subject: Re: LIKE operator with brackets in search
System discussion
list(ARSList)"
<[email protected]>
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: [email protected]
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:
[email protected]
<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: [email protected]
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.***
