If this is for an ITSM record, is there a reason you can't just change the config in the "SYS:Status Transition Rules" form?
Regards, Andrew Goodall Software Engineer 2 | Development Services | jcpenney . www.jcp.com -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Brittain, Mark Sent: Friday, May 20, 2011 11:49 AM To: arslist@ARSLIST.ORG Subject: Re: needs immediate help on this query.... "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." First off, couldn't you use an active link that changes to Resolved if Closed is selected? If you go with a filter I would suggest using ('DB.Status' != 'Status') AND ('Status' = 'Closed") This is doing the same thing as described below but IMHO is cleaner. Also if you added a status value later you would not have to go back and update this filter. FYI Mark -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of patchsk Sent: Friday, May 20, 2011 12:39 PM To: arslist@ARSLIST.ORG Subject: Re: needs immediate help on this query.... 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" This e-mail is the property of NaviSite, Inc. It is intended only for the person or entity to which it is addressed and may contain information that is privileged, confidential, or otherwise protected from disclosure. Distribution or copying of this e-mail, or the information contained herein, to anyone other than the intended recipient is prohibited. ________________________________________________________________________ _______ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug11 www.wwrug.com ARSList: "Where the Answers Are" The information transmitted is intended only for the person or entity to which it is addressed and may contain confidential and/or privileged material. If the reader of this message is not the intended recipient, you are hereby notified that your access is unauthorized, and any review, dissemination, distribution or copying of this message including any attachments is strictly prohibited. If you are not the intended recipient, please contact the sender and delete the material from any computer. _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug11 www.wwrug.com ARSList: "Where the Answers Are"