Try this:
(($OPERATION$ = "SET" AND (('DB.Status' < "Resolved") OR ('DB.Status'
= "Cancelled")))
OR ($OPERATION$ = "CREATE") ) AND ('Status' = "Closed")
On May 20, 10:59 am, Gerard Lafontant <[email protected]> wrote:
> All,
>
> Can anyone tell me what am i missing or is wrong from this query that's
> causing the filter not to fire (by pass) on new request; and only fires on
> modified existing request. Basically, i'm forcing user to keep away from
> using 'Closed' Status resolution and push them to use the 'Resolved' status
> upon closing a ticket.
>
> (('DB.Status' < "Resolved") OR ('DB.Status' = "Cancelled")) AND ('Status'
> = "Closed")
>
> Status Value Order:
> New=0
> Assigned=1
> In Progress=2
> Pending=3
> Resolved=4
> Closed=5
> Cancelled=6
>
> ___________________________________________________________________________
> ____
> UNSUBSCRIBE or access ARSlist Archives atwww.arslist.org
> attend wwrug11www.wwrug.comARSList: "Where the Answers Are"
_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
attend wwrug11 www.wwrug.com ARSList: "Where the Answers Are"
