Hi,
Yes, that is indeed a fast call, but if you remove the value, you will
make NO API call for the search, and NO SQL call, which is even better ;-)
I agree that this is not very obvious.
It would be so much better with an option called "Always create entry"
which would then disable both the qualifier and the if-any-match fields.
Best Regards - Misi, RRR AB, http://rrr.se
> Hi,
>
> My opinion about this is a little different from Misi's. Of course he is
> right as always, but the empty qualification means TRUE in a Set Field If,
> while it means FALSE in a Push Field If, and I personally don't like this
> difference.
>
> So in a push field if qualification where I want to make sure it returns
> false, I use '1' < 0 which is always false, but also always fast.
>
> Best regards,
> Jean-Louis Halleux
> ARSmarts Support
>
> On 23 Nov 2012, at 16:41, Misi Mladoniczky <[email protected]> wrote:
>
>> Hi,
>>
>> Doing the 1=2/0=1 is bad practice in Push-Fields.
>>
>> You should have the qualification blank and set the If Any Request Match
>> to Do Nothing. This will prevent accessing the database altogether.
>>
>> Some databases perform a table-scan on such a qualification...
>>
>> The only time I use it is when I want to run an Escalation Else action
>> every time the escalation runs. But in those cases I usually have a form
>> with zero records in it, which makes it fast anyway.
>>
>> Best Regards - Misi, RRR AB, http://www.rrr.se (ARSList MVP 2011)
>>
>> Products from RRR Scandinavia (Best R.O.I. Award at WWRUG10/11):
>> * 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,
>>>
>>> you can use it when you want to be sure that no requests match your
>>> qualification, for example when you need a push fields action to create
>>> a
>>> new request.
>>> I never use it though, I prefer 0=1.
>>>
>>> Happy Friday!
>>> Regards Michael
>>>
>>> From: Action Request System discussion list(ARSList)
>>> [mailto:[email protected]] On Behalf Of Jithin T.R
>>> Sent: Friday, November 23, 2012 1:38 PM
>>> To: [email protected]
>>> Subject: Re: 1=1 and 1=2 Query Usage...
>>>
>>> ** Can you give us some examples of using 1=2 in remedy and what is the
>>> benefit?
>>>
>>> Jithin
>>> On Fri, Nov 23, 2012 at 5:28 PM, Abhishek Gupta
>>> <[email protected]<mailto:[email protected]>> wrote:
>>> lways false
>>>
>>> _attend WWRUG12 www.wwrug.com<http://www.wwrug.com> ARSlist: "Where the
>>> Answers Are"_
>>>
>>> _______________________________________________________________________________
>>> UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
>>> attend wwrug12 www.wwrug12.com ARSList: "Where the Answers Are"
>>> ING-DiBa AG, Frankfurt am Main. Registernummer HRB 7727,
>>> Handelsregister
>>> Amtsgericht Frankfurt am Main. Vorstand: Roland Boekhout
>>> (Vorsitzender),
>>> Herbert Willius (stellv. Vorsitzender), Bas Brouwers, Bernd Geilen,
>>> Katharina Herrmann, Martin Krebs.
>>> Aufsichtsrat: Ben Tellings (Vorsitzender)
>>>
>>> Diese E-Mail enthält vertrauliche und/oder rechtlich geschützte
>>> Informationen. Wenn Sie nicht der richtige Adressat sind oder diese
>>> E-Mail irrtümlich erhalten haben, informieren Sie bitte sofort den
>>> Absender und vernichten Sie diese Mail.
>>> Das unerlaubte Kopieren sowie die unbefugte Weitergabe dieser Mail ist
>>> nicht gestattet.
>>>
>>> This e-mail may contain confidential and/or privileged information. If
>>> you are not the intended recipient (or have received this e-mail in
>>> error) please notify the sender immediately and destroy this e-mail.
>>> Any
>>> unauthorized copying, disclosure or distribution of the material in
>>> this
>>> e-mail is strictly forbidden.
>>>
>>> _______________________________________________________________________________
>>> UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
>>> attend wwrug12 www.wwrug12.com ARSList: "Where the Answers Are"
>>>
>>
>> _______________________________________________________________________________
>> UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
>> attend wwrug12 www.wwrug12.com ARSList: "Where the Answers Are"
>
> _______________________________________________________________________________
> UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
> attend wwrug12 www.wwrug12.com ARSList: "Where the Answers Are"
>
_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
attend wwrug12 www.wwrug12.com ARSList: "Where the Answers Are"
