Hi,
One very important thing is that values will never be "", it will be NULL.
Leading and trailing whitespace will also be stripped, so the string " "
would also be set to NULL.
AR User will automatically convert empty charfields to NULL.
When you do imports, leading and trailing whitespaces can be there, but
they will not be there for anything entered through AR User.
Other API-programs can send strings with leading and trailing whitespace,
which could possibly make things complicated.
Best Regards - Misi, RRR AB, http://www.rrr.se
Products from RRR Scandinavia:
* RRR|License - Not enough Remedy licenses? Save money by optimizing.
* RRR|Log - Performance issues or elusive bugs? Analyze your Remedy logs.
* RRR|Translator - Manage and automate your language translations.
Find these products, and many free tools and utilities, at http://rrr.se.
> 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: arslist@ARSLIST.ORG
> 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"
>
_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the
Answers Are"
