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"
