Derek, You may want to have any filters within the loop bypass phasing (add the ~! To the end of the Filter title) if you are doing any 2nd or 3rd phase actions in the filter
Bruce -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Derek Fernandes Sent: Monday, April 23, 2007 9:29 AM To: [email protected] Subject: Table Looping in a filter Hi listers, I am trying to loop though a table in a filter. First, is this even possible? (I haven't done anything like this before) I am trying to count the number of times something shows up in a table, however, it is not working. This is how I have set it up 1) I have a filter that fires on submit/modify of the form that the table is on: a) sets up some counters (outboundmessagecount = 0, loopcount = 1). b) Calls a filter guide with a Table Loop on the table I want to loop though. 2) The Filter Guide calls one filter (below) 3) Filter that loops through the table: Loops though the table if columnName = "Outbound" AND loopcount < 3 (*I want to see if the first 2 rows of the table are "Outbound" messages* *- this is the end goal of doing this - I want an integer value with this number*). a) If Action - outboundmessagecount = outboundmessagecount + 1 loopcount = loopcount + 1 b) Else Action - loopcount = loopcount + 1 All I get is loopcount = 2 and outboundmessagecount = 0 , so the If Action never fires. Is this because the table has to be refreshed before it can "read" from the table? How do you do this from a filter? Help. Thanks, Derek -- Derek Fernandes Programmer Analyst U of C Information Technologies ES 1010, University of Calgary Calgary, Alberta T2N 1N4 403.210.9879 ________________________________________________________________________ _______ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are" ##################################################################################### The information contained in this electronic mail message, including attachments, if any, is PetSmart confidential information. It is intended only for the use of the person(s) named above. If the reader of this message is not the intended recipient, or has received this message in error, you are hereby notified that any review, dissemination, distribution or copying of this communication is strictly prohibited. If you are not the intended recipient or have received this message in error, please notify the sender via e-mail and promptly delete the original message. ##################################################################################### _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"
