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 <gelaf...@gmail.com> 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"