arserverd generates a sql statement like this. select c1 from t<xxx> where 1=0 This statement does not return any rows and completes really fast, regardless the number of rows in the table. But if this filter action is triggered one million times a day you should left the "push field if" blank, because there will be no database interaction in this case and this will be faster. Kind Regards Conny
________________________________ Von: Action Request System discussion list(ARSList) [mailto:[email protected]] Im Auftrag von Sreenivas Gesendet: Freitag, 16. Oktober 2009 15:22 An: [email protected] Betreff: Re: [Probable SPAM] Re: Question Advance Query 1=0 ** My question here is if you place 1=0 in qualification does it search all the existing records and then create a new record (when you select Create a New Request in the If No Requests Match field). Sreeni _Platinum Sponsor: [email protected] ARSlist: "Where the Answers Are"_ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:[email protected] ARSlist: "Where the Answers Are"
