All fields in a Push Fields action are part of the push transaction yes, but for a standard modify of a form if they are not changed then the TR value is NULL.
>From the Workflow Objects PDF - Transaction Only-References the value of the field in the current transaction only. If the value is not changed in the transaction, it is considered to be $NULL$. If the operation is a delete, it is considered to be $NULL$. To specify a check of the transaction only, use the format 'TR.<field>' when you enter the field name in the Run If field. - Database Only-References the value of the field in the database only. No check is made of the value in the current transaction. If the operation is a create operation, it is considered to be $NULL$. To specify a reference of the database only, use the format 'DB.<field>' when you enter the field name in the Run If field. - Transaction and Database-References the value of the field in the current transaction and uses that value if changed. If not changed in the current transaction, references the value of the field in the database. To specify a reference of both the transaction and the database (in this order), use the format '<field>' when you enter the field name in the Run If field. From: Action Request System discussion list(ARSList) [mailto:[email protected]] On Behalf Of Thad K Esser Sent: Wednesday, April 14, 2010 3:58 PM To: [email protected] Subject: Re: TR vs DB sanity check please ** All fields that are specified in a push fields action are part of the TRansaction, and will therefore have a TR value, regardless of whether or not the value has changed. Thad Esser Remedy Developer From: Tommy Morris <[email protected]> To: [email protected] Date: 04/14/2010 01:48 PM Subject: Re: TR vs DB sanity check please Sent by: "Action Request System discussion list(ARSList)" <[email protected]> ________________________________ ** I understand how Rick put it that the TR is implied so you don't have to specify it but why would including the identifier cause an erroneous result? From: Action Request System discussion list(ARSList) [mailto:[email protected]] On Behalf Of Thad K Esser Sent: Wednesday, April 14, 2010 3:44 PM To: [email protected] Subject: Re: TR vs DB sanity check please ** Tommy, In some situations, your version will evaluate to true, even though nothing changed. To truly detect if a value changed, its best to use: 'AssignedToTech' != 'DB.AssignedToTech' Thad Esser Remedy Developer From: Tommy Morris <[email protected]> To: [email protected] Date: 04/14/2010 01:39 PM Subject: Re: TR vs DB sanity check please Sent by: "Action Request System discussion list(ARSList)" <[email protected]> ________________________________ Instead of Runif: 'AssignedToTech' != 'AssignedToTech' Make it Runif: 'TR.AssignedToTech' != 'DB.AssignedToTech' -----Original Message----- From: Action Request System discussion list(ARSList) _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: "Where the Answers Are"
