Lisa you can write that one of two ways....
( 'Status' = "ACTIVE") AND ('tmp_SurveyDate' = $NULL$) AND (( 'Q1' !=
$NULL$ ) AND ( 'Response 1' = $NULL$ ) OR ( 'Q2' != $NULL$ ) AND (
'Response 2' = $NULL$ ))
if that still doesn't work then something like this might stick:
(( 'Status' = "ACTIVE") AND ('tmp_SurveyDate' = $NULL$) AND ( 'Q1' !=
$NULL$ ) AND ( 'Response 1' = $NULL$ )) OR (( 'Status' = "ACTIVE") AND
('tmp_SurveyDate' = $NULL$) AND ( 'Q2' != $NULL$ ) AND ( 'Response 2' =
$NULL$ ))
Ben Cantatore
Remedy Administrator
Avon
(914) 935-2946
"Kemes, Lisa" <[EMAIL PROTECTED]>
Sent by: "Action Request System discussion list(ARSList)"
<arslist@ARSLIST.ORG>
02/05/2008 01:43 PM
Please respond to
arslist@ARSLIST.ORG
To
arslist@ARSLIST.ORG
cc
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___
_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
