Not entirely true. If you only look at TR.field != DB.field then any time the value doesn't change and the DB value isn't null that evaluates to true. The original qualification of ( 'TR.field' != $NULL$ ) AND ( 'TR.field' != 'DB.field' Is one of the proper ways to check if a field is changing. As long as you are not looking for it changing to null
-----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Moore, Chris Sent: Monday, July 09, 2007 10:19 AM To: arslist@ARSLIST.ORG Subject: Re: Help with Run-If Qualification It's my understanding that a TR value only exists if it's != to the DB value- it exists because it's different, so the qualification "TR.field != $NULL$" is the same as "TR.field != DB.field". So ('TR.Assigned To' != $NULL$ AND 'Status' != "Assigned") should work. Also, sorry if this is obvious, but TR and DB values can onlu be checked with filters, not Active links. Chris -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Niu, Jason Sent: Monday, July 09, 2007 11:13 AM To: arslist@ARSLIST.ORG Subject: Re: Help with Run-If Qualification ( 'TR.MDS_IT_Assigned_to' !=DB.MDS_I Qualification: ( 'TR.MDS_IT_Assigned_to' != 'DB.MDS_IT_Assigned_to') AND ( 'MDS_IT_Status' != "Assigned") If action, Message, Error. Jason Niu Remedy System & Operation GETS - Enterprise Systems Management Email: [EMAIL PROTECTED] 135 W 50th Street, NYC,NY,10020 -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Rich Wallingford Sent: Monday, July 09, 2007 10:55 AM To: arslist@ARSLIST.ORG Subject: [ARSLIST] Help with Run-If Qualification Hi all - ARS 5.1.2 Oracle Win2k3 Here's my problem ... I want to give an error message if a tech tries to reassign a ticket without the status being set to "Assigned". Here's my Run-If qualification ... ( 'TR.MDS_IT_Assigned_to' != $NULL$ ) AND ( 'TR.MDS_IT_Assigned_to' != 'DB.MDS_IT_Assigned_to') AND ( 'MDS_IT_Status' != "Assigned") This is not working. Thanks Rich "CONFIDENTIALITY NOTICE: This communication, including any attachments, may contain confidential information and is intended only for the individual or entity to whom it is addressed. Any review, dissemination, or copying of this communication by anyone other than the intended recipient is strictly prohibited. If you are not the intended recipient, please contact the sender by reply email and delete and destroy all copies of the original message." ________________________________________________________________________ _______ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are" ----------------------------------------- The information contained in this transmission may be privileged and confidential and is intended only for the use of the person(s) named above. If you are not the intended recipient, or an employee or agent responsible for delivering this message to the intended recipient, any review, dissemination, distribution or duplication of this communication is strictly prohibited. If you are not the intended recipient, please contact the sender immediately by reply e-mail and destroy all copies of the original message. Please note that we do not accept account orders and/or instructions by e-mail, and therefore will not be responsible for carrying out such orders and/or instructions. If you, as the intended recipient of this message, the purpose of which is to inform and update our clients, prospects and consultants of developments relating to our services and products, would not like to receive further e-mail correspondence from the sender, please "reply" to the sender indicating your wishes. In the U.S.: 1345 Avenue of the Americas, New York, NY 10105. ________________________________________________________________________ _______ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are" ____________________________________________________________________________ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are" _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"