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 <m...@rrr.se> 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:arslist@ARSLIST.ORG] On Behalf Of Jithin T.R >> Sent: Friday, November 23, 2012 1:38 PM >> To: arslist@ARSLIST.ORG >> 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 >> <mailsabhi2...@gmail.com<mailto:mailsabhi2...@gmail.com>> 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"