I hate when these discussions start again. Your original qualification will work for ensuring that you capture change. Introducing TR into the mix then makes you consider 'is it going to null' etc...but the simple one you have defined originally should check to see if it's changing.
_____ From: Action Request System discussion list(ARSList) [mailto:[email protected]] On Behalf Of Frank Caruso Sent: Tuesday, June 23, 2009 11:27 AM To: [email protected] Subject: Re: Filter qualification: verify a field value has NOT changed ** 'TR.FieldA' = $NULL$ and 'DB.FieldA' != $NULL$ You mentioned changed so I am thinking the database has an actual value but the user is not changing the value On Tue, Jun 23, 2009 at 8:21 PM, Givens, Gregory CONT <[email protected]> wrote: 'TR.FieldA' = $NULL$ -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[email protected]] On Behalf Of Wacholz, Jeanette (Jenni) Sent: Tuesday, June 23, 2009 12:12 PM To: [email protected] Subject: Filter qualification: verify a field value has NOT changed ** Hi Listers, I know this is elementary but my brain is chasing itself in circles today. I need a qualification to ensure that a filter will only fire if a field value has not changed. Will 'FieldA' = 'DB.FieldA' do it or am I missing something? Jenni Wacholz Remedy Developer Coventry Health Care Inc 480-445-2517 Email Confidentiality Notice: The information contained in this transmission is confidential, proprietary or privileged and may be subject to protection under the law, including the Health Insurance Portability and Accountability Act (HIPAA). The message is intended for the sole use of the individual or entity to whom it is addressed. If you are not the intended recipient, you are notified that any use, distribution or copying of the message is strictly prohibited and may subject you to criminal or civil penalties. If you received this transmission in error, please contact the sender immediately by replying to this email and delete the material from any computer. _Platinum Sponsor: [email protected] ARSlist: "Where the Answers Are"_ ____________________________________________________________________________ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:[email protected] <mailto:sponsor%[email protected]> ARSlist: "Where the Answers Are" _Platinum Sponsor: [email protected] ARSlist: "Where the Answers Are"_ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:[email protected] ARSlist: "Where the Answers Are"
