Thank you all for your responses! You have been very helpful. Since the field in question will always have a value in it and I just need to ensure that the value has not changed, it sounds like my original qualification should work.
Jenni Wacholz Remedy Developer Coventry Health Care Inc 480-445-2517 ________________________________ From: Action Request System discussion list(ARSList) [mailto:[email protected]] On Behalf Of Lyle Taylor Sent: Tuesday, June 23, 2009 10:39 AM To: [email protected] Subject: Re: Filter qualification: verify a field value has NOT changed ** I think 'DB.FieldA' = 'FieldA' like you had should be sufficient unless you care if the value is actively being set to what it was before (e.g., they cleared the field but reselected/re-entered the same value, etc. - this also can happen during reconciliation in the CMDB), or if the value can be NULL. If the value can be NULL, then you might have to have something like this: ('DB.FieldA' = 'FieldA') OR ('DB.FieldA' = $NULL$ AND 'FieldA' = $NULL$) Lyle 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"_ NOTICE: This email message is for the sole use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply email and destroy all copies of the original message. _Platinum Sponsor: [email protected] ARSlist: "Where the Answers Are"_ 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. _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:[email protected] ARSlist: "Where the Answers Are"

