I would modify your statement to be the following:
( 'Resource Type' = $Request Type$) AND (( 'Restrict Region' = "1") AND (
'Resource Region' = $Request Region$))
This will do the same thing as your original intended query.
Bruce
-----Original Message-----
From: Action Request System discussion list(ARSList) on behalf of
Carter, Craig J Civ ARPC/DPD
Sent: Wed 4/18/2007 8:14 AM
To: [email protected]
Cc:
Subject: Re: Table Qualifications / Parenthesis
**
You do need the extra $ at the end of the Request Region field so it’s
fixing that—your original entry is not valid.
CRAIG J. CARTER
_____
From: Action Request System discussion list(ARSList) [mailto:[EMAIL
PROTECTED] On Behalf Of Durrant, Michael M. - ITSD
Sent: Wednesday, April 18, 2007 8:56 AM
To: [email protected]
Subject: Table Qualifications / Parenthesis
Running Admin Tool 7.0.1 patch 002
I build the following qualification:
('Resource Type' = $Request Type$) AND ('Restrict Region' = "1" AND
'Resource Region' = $Request Region)
When I click save, Admin Tool decides that
( 'Resource Type' = $Request Type$) AND ( 'Restrict Region' = "1") AND
( 'Resource Region' = $Request Region$)
is actually what I want and this second (broken) qualification is what
ends up being saved.
Am I crazy or stupid or?
Michael Durrant
IT Systems Integration Analyst
Division of Information Technology
Idaho Department of Health and Welfare
Email: [EMAIL PROTECTED]
Share what you know. Learn what you don't.
----------------------------------------------------------
Computer problems? Please call the IT Help Desk at 800-399-3503 or
email [EMAIL PROTECTED] Please do not send requests for assistance directly to
me as I may not be able to respond immediately.
The information contained in this email may be privileged, confidential
or otherwise protected from disclosure. All persons are advised that they may
face penalties under state and federal law for sharing this information with
unauthorized individuals. If you received this email in error, please reply to
the sender that you have received this information in error. Also, please
delete this email after replying to the sender.
__20060125_______________________This posting was submitted with HTML
in it___ __20060125_______________________This posting was submitted with HTML
in it___
#####################################################################################
The information contained in this electronic mail message, including
attachments, if any, is PetSmart confidential information. It is intended only
for the use of the person(s) named above. If the reader of this message is not
the intended recipient, or has received this message in error, you are hereby
notified that any review, dissemination, distribution or copying of this
communication is strictly prohibited. If you are not the intended recipient or
have received this message in error, please notify the sender via e-mail and
promptly delete the original message.
#####################################################################################
