Yes.
You really can't use 'TR.FieldA' as a test unless the field cannot be
NULL ( The 'TR.FieldA' will be NULL if someone is changing that field to
NULL as well). You may also need to do a specific Null check for each
as well.
('FieldA' = 'DB.FieldA') OR (('FieldA' = $NULL$) AND ('DB.FieldA' =
$NULL$))
Fred
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
_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor:[email protected] ARSlist: "Where the Answers Are"
