Hi Gerard,
Since it is a new request, the DB.Status is NULL. I would make the Run If be:
(('DB.Status' < "Resolved") OR ('DB.Status' = "Cancelled") OR ('DB.Status' =
$NULL$)) AND ('Status' = "Closed")
Hope this fixes it. Thanks!
Greg
From: Action Request System discussion list(ARSList)
[mailto:[email protected]] On Behalf Of Gerard Lafontant
Sent: Friday, May 20, 2011 10:59 AM
To: [email protected]
Subject: needs immediate help on this query....
** 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 _attend WWRUG11 www.wwrug.com ARSlist: "Where the Answers Are"_
_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
attend wwrug11 www.wwrug.com ARSList: "Where the Answers Are"
