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"

Reply via email to