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"
