Mark is correct - I think you need to add a 'DB.Status' = null into your criteria - as on submit the db status won't contain a value.
Regards, Andrew Goodall Software Engineer 2 | Development Services | jcpenney . www.jcp.com <http://www.jcp.com/> ________________________________ From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Gerard Lafontant Sent: Friday, May 20, 2011 10:59 AM To: arslist@ARSLIST.ORG 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"_ </pre><font face="monospace"size="-3"><br>The information transmitted is intended only for the person or entity to which it is addressed and <br>may contain confidential and/or privileged material. If the reader of this message is not the intended<br>recipient, you are hereby notified that your access is unauthorized, and any review, dissemination,<br>distribution or copying of this message including any attachments is strictly prohibited. If you are not<br>the intended recipient, please contact the sender and delete the material from any computer.<br><pre> _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug11 www.wwrug.com ARSList: "Where the Answers Are"
