I wrote a little application that you might find useful:
http://ungil.com/remedy/ARSqueryeditor.html
Cheers,
Carlos
On Feb 5, 2008 7: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"
