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 at www.arslist.org
attend wwrug11 www.wwrug.com ARSList: "Where the Answers Are"
