I believe it was implemented (leaving the qualification blank) in v6.0 (or 6.3). There was even a session at RUG 2005 on performance tuning that talked about removing the 1=0 from the Push Fields (to eliminate the database call completely).
Fred From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Lyle Taylor Sent: Friday, October 16, 2009 7:18 PM To: arslist@ARSLIST.ORG Subject: Re: Question Advance Query 1=0 ** I believe 7.1 behaves this way as well. I have workflow that makes this assumption, and it all appears to work as expected. Lyle From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Brien Dieterle Sent: Thursday, October 15, 2009 10:59 AM To: arslist@ARSLIST.ORG Subject: Re: Question Advance Query 1=0 ** FYI (from 7.5 docs): To create a Push Fields action that does not search for existing records, but instead always creates a new request, do not enter any qualification. In this case, make sure to select Create a New Request in the If No Requests Match field and Take No Action in the If Any Requests Match field. Brien Dieterle Misi Mladoniczky wrote: Hi! I do not know about the advanced search, but I have often seen (1=0) used in a Push-Fields-Action (FLTR/ACTL) where you allways want to create new records. I have used it myself to trigger the no-match-action in escalations, when I want to run a single operation for example each night. The (1=1) is typically used to show everything in systems where that do not allow Unqualified Queries, which is a server setting. 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. ARSList, Here is a interesting question for the list. I was presented a question about 1=1 and 1=0 on the advance query bar. This qualification is used in out of the box Service Level Targets for ITSM 7.1. (1=0). Why would you use 1=0? How would you use 1=0? Can anybody explain? Robert Thomas | BMC/Remedy Professional | ITIL | Cellular Phone 469.865.5645| _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are"