Lisa, Tip:
When I need to edit a qualification where ARS automatically (and not wanted) adds a bunch of parenthesis, I copy/paste the entire qualification into notepad and quickly perform a search & replace for ) and then for ( to remove all parenthesis. Then I add back the few parentheses that actually mean something and then copy/paste back into the ARS object. If I know I will be working and testing the qualification for a while I leave notepad open (with the qualification text). This way I can do all my editing in notepad and not have to deal with ARS continually adding its own parenthesis. HTH Stephen Remedy Skilled Professional -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Kemes, Lisa Sent: Tuesday, February 05, 2008 1:54 PM To: arslist@ARSLIST.ORG Subject: Re: Parenthesis This worked, Thanks everyone!! Lisa -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Axton Sent: Tuesday, February 05, 2008 1:48 PM To: arslist@ARSLIST.ORG Subject: Re: Parenthesis ( 'Status' = "ACTIVE") AND ('tmp_SurveyDate' = $NULL$) AND ((( 'Q1' != $NULL$ ) AND ( 'Response 1' = $NULL$ )) OR (( 'Q2' != $NULL$ ) AND ( 'Response 2' = $NULL$ ))) On Feb 5, 2008 1:43 PM, Kemes, Lisa <[EMAIL PROTECTED]> wrote: > ** > > > 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" ________________________________________________________________________ _______ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
