( 'Status' = "ACTIVE") AND ('tmp_SurveyDate' = $NULL$) AND (( 'Q1' !=
$NULL$ ) AND ( 'Response 1' = $NULL$ )) OR (( 'Q2' != $NULL$ ) AND (
'Response 2' = $NULL$ ))
________________________________
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Kemes, Lisa
Sent: Tuesday, February 05, 2008 1:44 PM
To: [email protected]
Subject: Parenthesis
**
I'm having a heck of a time trying to get this Run If statement
to work:
(( 'Status' = "ACTIVE") AND ('tmp_SurveyDate' = $NULL$) AND (
'Q1' != $NULL$ ) AND ( 'Response 1' = $NULL$ )) OR (( 'Q2' != $NULL$
) AND ( 'Response 2' = $NULL$ ))
I want this filter to run if: (Q1 is not null and Response 1 is
Null) OR (Q2 is not Null or Response 2 is Null) but only if the Status
is Active and the tmp_SurveyDate is Null
No matter where I put my parenthesis, Remedy keeps putting them
where it wants to and it's running my filter even though the
tmp_SurveyDate field NOT Null.
Any ideas?
Lisa Kemes
AR System Developer
Tyco Electronics
717-810-2408 tel
717-810-2124 fax
[EMAIL PROTECTED]
__Platinum Sponsor: www.rmsportal.com ARSlist: "Where the
Answers Are" html___
This e-mail transmission contains information that is confidential and may be
privileged.
It is intended only for the addressee(s) named above. If you receive this
e-mail in error,
please do not read, copy or disseminate it in any manner. If you are not the
intended
recipient, any disclosure, copying, distribution or use of the contents of this
information
is prohibited. Please reply to the message immediately by informing the sender
that the
message was misdirected. After replying, please erase it from your computer
system. Your
assistance in correcting this error is appreciated.
_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
