Hi Jenni
Gregory says 'TR.FieldA' = $NULL$ This will miss cases where the field is being changed TO null from a non-null value Frank says 'TR.FieldA' = $NULL$ and 'DB.FieldA' != $NULL$ This will normally work correctly. But if you have a push fields action pushing values to the form, where the TR value is the same as the DB value and is non-null, this will be incorrect. Jenni says 'FieldA' = 'DB.FieldA' This will always give the expected result. HTH David Sanders Remedy Solution Architect Enterprise Service Suite @ Work ========================== tel +44 1494 468980 mobile +44 7710 377761 email <mailto:[email protected]> [email protected] web <http://www.westoverconsulting.co.uk/> http://www.westoverconsulting.co.uk _____ From: Action Request System discussion list(ARSList) [mailto:[email protected]] On Behalf Of Frank Caruso Sent: Tuesday, June 23, 2009 6:27 PM 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"
