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: [email protected]
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)" <[email protected]> To
[email protected]
cc
10/11/2006 10:31 AM
Subject
Re: LIKE operator
Please respond to with brackets in
[email protected] 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:
[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.***
__20060125_______________________This posting was submitted with HTML in
it___
_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org
