Hi,
I am not talking about a FLTR Run If, but of the search criteria in a
FLTR/ACTL Set-Fields/Push-Fields operation.
If you are talking about the FLTR Run If, there should be no access to the
database. The expression will be evaluated inside of the AR Server, and
could work differently from how a Database-search would be matched.
The databases may not support some matches in the LIKE statement, but the
FLTR-Run-If will, as it has nothing to do with the database.
For example ('Company' LIKE "[A-Z][^0-9]%").
This would match any value starting with a letter A to Z that is not
followed by a number. If the Company-field is not included in the
transaction data, the database value will be retrieved before any FLTR is
executed.
In any event you ar right, but I think you are talking about something
else...
Best Regards - Misi, RRR AB, http://www.rrr.se
Products from RRR Scandinavia (Best R.O.I. Award at WWRUG10):
* RRR|License - Not enough Remedy licenses? Save money by optimizing.
* RRR|Log - Performance issues or elusive bugs? Analyze your Remedy logs.
Find these products, and many free tools and utilities, at http://rrr.se.
>
> Hi Misi et al,
>
> Think about it, a filter qualification is a memory operation. There is no
> database query. The transaction and db values are in memory as are the
> set of filters to be evaluated. Else you would get an error when a filter
> qual has a DO field on it.
>
> Cheers
> Ben
>
> -----Original Message-----
> From: Action Request System discussion list(ARSList)
> [mailto:[email protected]] On Behalf Of Misi Mladoniczky
> Sent: November-17-10 08:12
> To: [email protected]
> Subject: Re: LIKE Query
>
> Hi,
>
> Are you really sure about that???
>
> I is easy to try out using Advanced Search. I would be surprised if there
> were any difference...
>
> I just tried it on my ARServer 7.6.03 with SQL Server 2008 R2, and both
> version gave te same result.
>
> If you write an ACTL/FLTR Set-Fields with the following query:
> ('Company' LIKE $Company$ + "%")
>
> It will be converted to something like:
> SELECT C1,C8 FROM T99 WHERE C536870913 LIKE 'RRR' + '%'
>
>>From what I know about SQL, both of these should work the same:
> ... WHERE C536870913 LIKE 'RRR' + '%'
> ... WHERE C536870913 LIKE 'RRR%'
>
> Best Regards - Misi, RRR AB, http://www.rrr.se
>
> Products from RRR Scandinavia (Best R.O.I. Award at WWRUG10):
> * RRR|License - Not enough Remedy licenses? Save money by optimizing.
> * RRR|Log - Performance issues or elusive bugs? Analyze your Remedy logs.
> Find these products, and many free tools and utilities, at http://rrr.se.
>
>> What database are you on?
>>
>> If I recollect right, MS-SQL was picky between LIKE Company + %
>> ***and*** LIKE Company% .
>>
>> It used to not like LIKE Company%
>>
>> On Oracle and the later versions of MS-SQL, both should return
>> consistent results..
>>
>> Joe
>>
>>
>>
>> From: Coleman, Gavin
>> Sent: Tuesday, November 16, 2010 7:43 AM
>> Newsgroups: public.remedy.arsystem.general
>> To: [email protected]
>> Subject: LIKE Query
>>
>> **
>> Hi List we ve got an interesting problem here.
>>
>>
>>
>> What is the difference between the following:
>>
>>
>>
>> LIKE Company + %
>>
>>
>>
>> LIKE Company%
>>
>>
>>
>> I would have assumed nothing, but one of these works and one doesn t.
>> Is there anybody that can explain the difference? I ve run across this
>> before, but never really wanted to find out WHY it worked / didn t work.
>>
>>
>>
>> The above qualification occurs in a Filter Run If statement.
>>
>>
>>
>> Thanks,
>>
>>
>>
>>
>>
>>
>>
>> Gavin Coleman
>>
>> Senior Analyst/Programmer
>>
>> Computacenter (UK) Ltd
>>
>> Services & Solutions
>>
>> Hatfield Avenue
>>
>> Hatfield, Hertfordshire, AL10 9TW, United Kingdom
>>
>> T: +44 (0) 1707 631662
>>
>> E: [email protected]
>>
>> W: www.computacenter.com
>>
>>
>>
>>
>> **********************************************************************
>> COMPUTACENTER PLC is registered in England and Wales with the
>> registered number 03110569. Its registered office is at Hatfield
>> Business Park, Hatfield Avenue, Hatfield, Hertfordshire AL10 9TW
>> COMPUTACENTER (UK) Limited is registered in England and Wales with the
>> registered number 01584718. Its registered office is at Hatfield
>> Business Park, Hatfield Avenue, Hatfield, Hertfordshire AL10 9TW
>> COMPUTACENTER (Mid-Market) Limited is registered in England and Wales
>> with the registered number 3434654. Its registered office is at
>> Hatfield Business Park, Hatfield Avenue, Hatfield, Hertfordshire AL10
>> 9TW COMPUTACENTER (FMS) Limited is registered in England and Wales
>> with the registered number 3798091. Its registered office is at
>> Hatfield Business Park, Hatfield Avenue, Hatfield, Hertfordshire AL10
>> 9TW
>>
>> The contents of this email are intended for the named addressee only.
>> It contains information which may be confidential and which may also
>> be privileged.
>> Unless you are the named addressee (or authorised to receive mail for
>> the
>> addressee) you may not copy or use it, or disclose it to anyone else.
>> If you receive it in error please notify us immediately and then
>> destroy it.
>> Computacenter information is available from:
>> http://www.computacenter.com
>> **********************************************************************
>>
>> ______________________________________________________________________
>> _________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
>> attend wwrug11 www.wwrug.com ARSList: "Where the Answers Are"
>>
>
> _______________________________________________________________________________
> UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug11
> www.wwrug.com ARSList: "Where the Answers Are"
>
>
_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
attend wwrug11 www.wwrug.com ARSList: "Where the Answers Are"
