I think what you want instead of this:
( 'TR.AssignedConfigTech' != $NULL$ ) AND ('TR.AssignedConfigTech' !=
"")
Is this:
( 'TR.AssignedConfigTech' != $NULL$ ) AND ('TR.AssignedConfigTech' !=
'DB.AssignedConfigTech')
The first part of the qualification tells you that the
AssignedConfigTech is one of the fields involved in the transaction.
The second part of the qualification checks if what's in the transaction
is not the same text as what's already in the database.
With your qualification, if I have the value "John" in the DB and I push
"John" again, your filter will fire, but technically, nothing changed.
-----Original Message-----
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Dave.ARSList
Sent: Thursday, October 04, 2007 3:08 PM
To: [email protected]
Subject: Re: Filter Problem
Andy,
I don't think what you said is true - "( 'AssignedConfigTech' != $NULL$
)
AND ( 'DB.AssignedConfigTech' != 'TR.AssignedConfigTech')
If I am reading the statement correctly, the filter should not fire
unless
the 'AssignedConfigTech' is changed. "
If you really want to fire the filter when 'AssignedConfigTech' is
changed,
your condition should be:
( 'TR.AssignedConfigTech' != $NULL$ ) AND ('TR.AssignedConfigTech' !=
"")
Gurus, correct me if this is wrong.
- Dave.
Mayfield, Andy L. wrote:
>
> OK, I am stumped. I have a filter firing that should not be.
>
>
>
> I have a filter that sends a notification based on the qualification
> statement:
>
>
>
> ( 'AssignedConfigTech' != $NULL$ ) AND ( 'DB.AssignedConfigTech' !=
> 'TR.AssignedConfigTech')
>
>
>
> If I am reading the statement correctly, the filter should not fire
> unless the 'AssignedConfigTech' is changed.
>
>
>
> This filter is firing when the form is saved without a change being
made
> the 'AssignedConfigTech' field.
>
>
>
> There is a value in the field, so it's != $NULL$, but no change is
being
> made to the field so it should not meet the criteria.
>
>
>
> Andy L. Mayfield
> Sr. System Operation Specialist
> Alabama Power Company
> Office: 8-226-1805
> Cell: 288-9140
> SoLinc: 19140
>
>
>
>
>
________________________________________________________________________
_______
> UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
ARSlist:"Where
> the Answers Are"
>
> BEGIN:VCARD
> VERSION:2.1
> N:Mayfield;Andy
> FN:Mayfield, Andy L.
> ORG:APC;Technical Services
> TITLE:System Operations Spec Sr
> TEL;WORK;VOICE:8-226-1805
> ADR;WORK:;West Jefferson;2901 Allison-Bonnett Memorial
> Drive;Hueytown;AL;350231835;USA
> LABEL;WORK;ENCODING=QUOTED-PRINTABLE:West Jefferson=0D=0A2901
> Allison-Bonnett Memorial Drive=0D=0AHueytown, AL 35=
> 0231835=0D=0AUSA
> EMAIL;PREF;INTERNET:[EMAIL PROTECTED]
> REV:20070626T132537Z
> END:VCARD
>
>
--
View this message in context:
http://www.nabble.com/Filter-Problem-tf4558880.html#a13047833
Sent from the ARS (Action Request System) mailing list archive at
Nabble.com.
________________________________________________________________________
_______
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where
the Answers Are"
_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the
Answers Are"
