Hi,
Sorry, but this is not true.
This tracks all changes:
'AssignedToTech' != 'DB.AssignedToTech'
This tracks all changes if the field is not changed TO $NULL$:
'TR.AssignedToTech' != 'DB.AssignedToTech' and 'TR.AssignedToTech' != $NULL$
If this is a Resuired field, the end result would be the same.
The redundancy of the last statement is true, but if you want to track
that a change has occured to a non-null-value, I would write:
'AssignedToTech' != 'DB.AssignedToTech' AND 'AssignedToTech' != $NULL$
(i removed the TR on the last field)
Best Regards - Misi, RRR AB, http://www.rrr.se
Products from RRR Scandinavia:
* RRR|License - Not enough Remedy licenses? Save money by optimizing.
* RRR|Log - Performance issues or elusive bugs? Analyze your Remedy logs.
Find these products, and many free tools and utilities, at http://rrr.se.
> 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"
>
> --
> This message was scanned by ESVA and is believed to be clean.
>
>
_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
attend wwrug10 www.wwrug.com ARSlist: "Where the Answers Are"
