I had to use this today on a Push/filter to create records on a change to a join form. Without it there it would only create one record in the form. Once it was in the push if it created all the records I needed. Still having other issue however it worked well.
Duncan _____ From: Action Request System discussion list(ARSList) [mailto:[email protected]] On Behalf Of Conny Martin Sent: October 16, 2009 1:11 PM To: [email protected] Subject: AW: [Probable SPAM] Re: Question Advance Query 1=0 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"_ _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"
