Actually, that is not correct - the first two statements are NOT equal. The first statement will fire if AssignedToTech is set to $NULL$, and the database value is NOT $NULL$. The second statement will not.
However, the second and third statements are essentially equivalent - they will both fire if the value is changed to any non-null value that doesn't match the database value. From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of cpgold Sent: Thursday, April 15, 2010 4:27 PM To: arslist@ARSLIST.ORG Subject: Re: TR vs DB sanity check please ** NOTE Listers: 'AssignedToTech' != 'DB.AssignedToTech' is equal to 'TR.AssignedToTech' != 'DB.AssignedToTech' and 'TR.AssignedToTech' != $NULL$ this qual 'AssignedToTech' != 'DB.AssignedToTech' AND 'TR.AssignedToTech' != $NULL$ is redundant. On Thu, Apr 15, 2010 at 12:02 PM, Tanner, Doug <doug.tan...@compass-usa.com<mailto:doug.tan...@compass-usa.com>> wrote: Foolproof method (assuming the field is NOT required at the database level) 'AssignedToTech' != 'DB.AssignedToTech' AND 'TR.AssignedToTech' != $NULL$ -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG<mailto:arslist@ARSLIST.ORG>] On Behalf Of Brien Dieterle Sent: Thursday, April 15, 2010 12:50 PM To: arslist@ARSLIST.ORG<mailto:arslist@ARSLIST.ORG> Subject: Re: TR vs DB sanity check please Maybe add an AND 'TR.AssignedToTech' != $NULL$ Brien On 4/15/2010 9:28 AM, Drew Shuller wrote: > I typed the email wrong. > > I've tried the Run If as both 'TR.AssignedToTech' != 'DB.AssignedToTech' > and without the TR in the first instance. > > I'm running a Notify action. I do get inconsistent results. > > Drew > > _______________________________________________________________________________ > UNSUBSCRIBE or access ARSlist Archives at > www.arslist.org<http://www.arslist.org/> > attend wwrug10 www.wwrug.com<http://www.wwrug.com/> ARSlist: "Where the > Answers Are" > > _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org<http://www.arslist.org/> attend wwrug10 www.wwrug.com<http://www.wwrug.com/> ARSlist: "Where the Answers Are" DISCLAIMER Important! This message is intended for the above named person(s) only and is CONFIDENTIAL AND PROPRIETARY. If you are not the intended recipient of this e-mail and have received it in error, please immediately notify the sender by return email and then delete it from your mailbox. This message may be protected by the attorney-client privilege and/or work product doctrine. Accessing, copying, disseminating or re-using any of the information contained in this e-mail by anyone other than the intended recipient is strictly prohibited. Finally, you should check this email and any attachments for the presence of viruses, as the sender accepts no liability for any damage caused by any virus transmitted by this email. Thank you. _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org<http://www.arslist.org/> attend wwrug10 www.wwrug.com<http://www.wwrug.com/> ARSlist: "Where the Answers Are" _attend WWRUG10 www.wwrug.com ARSlist: "Where the Answers Are"_ NOTICE: This email message is for the sole use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply email and destroy all copies of the original message. _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: "Where the Answers Are"