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]<mailto:[email protected]>> wrote:
'TR.FieldA' = $NULL$
-----Original Message-----
From: Action Request System discussion list(ARSList)
[mailto:[email protected]<mailto:[email protected]>] On Behalf Of Wacholz,
Jeanette (Jenni)
Sent: Tuesday, June 23, 2009 12:12 PM
To: [email protected]<mailto:[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]<mailto:[email protected]> ARSlist: "Where the
Answers Are"_
_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at
www.arslist.org<http://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.
_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor:[email protected] ARSlist: "Where the Answers Are"
