Now if you only want to fire on a change in value not when a value goes from Null to being filled in then its 'AssignedToTech' != 'DB.AssignedToTech' AND 'DB.AssignedToTech' != $NULL$
On Thu, Apr 15, 2010 at 5:26 PM, cpgold <[email protected]> wrote: > 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 < > [email protected]> 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: >> [email protected]] On Behalf Of Brien Dieterle >> Sent: Thursday, April 15, 2010 12:50 PM >> To: [email protected] >> 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 >> > attend wwrug10 www.wwrug.com ARSlist: "Where the Answers Are" >> > >> > >> >> >> _______________________________________________________________________________ >> UNSUBSCRIBE or access ARSlist Archives at www.arslist.org >> attend wwrug10 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 >> attend wwrug10 www.wwrug.com ARSlist: "Where the Answers Are" >> > > _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: "Where the Answers Are"
