I ran into something similar to this when I was working on using filters to import CTM:People records from a table. Turned out the problem was in the filter itself. I found that a server-side table walk that runs into an error in a set fields/push fields operation fails to move on to the next record. In my case, an OOB error on CTM:People (i.e. no site name) would cause the record I was pushing to fail and although the table loop would walk on to the next record the push fields action wouldn't. So the filters in the loop would, using your example, run 5 times but would push the 3rd record 3 times. Is that what you are seeing?
An idea, as a test, might be to create a new form that has just the fields you want to set using your table loop. Change the set fields to a push fields to the new form and always create a new record. See if you get three different records or three copies of the same record. If you get three different ones you might be able to the put a filter on the new form (sort of a staging form) and have it push to your original form. If you get the same one three times, or only one record, we'll have to take a different approach. J.T. Shyman Column Technologies [EMAIL PROTECTED] From: Tanner, Doug Sent: Wed 12/26/2007 10:05 AM To: [email protected] Subject: Server Side Table - Filter Loop ** zTmpField2 is on my Request (Form) along with the table, I am trying to set it from a column within the table field. I am on ARS 6.3 Patch 21 (Table Field) References a form that has (4) fields of importance Request ID (Field 1) Instance ID of the Parent A true attachment Field Include in Resolution (Check Box) The desired result is to loop the table finding up to 3 attachments that have the Parent ID and also are marked to include in the Resolution Email. The true attachment pool is in my template for the outbound email. In the above Example there are a total of 5 attachments, but only three are marked with "Resolution". The Filter guide will skip the first 2 as the run if qualification is 'col_AT Resolution' = "Resolution" Then the Filter does the following (2) Set Fields - Set zTmpField2 to the Request ID of the Attachment table match - The go get the true attachment The next two filters are designed to (Attachment Field1 of the Attachment Pool) (Attachment Field2 of the Attachment Pool) I have already implemented a work around and have the system attaching up to the 3 attachments, but I would rather perform this with a Filter Guide doing a server side table loop. I thought phasing as well and tried the Tick/Bang (`!) before posting So I have a filter calling guide, mark as a table loop There are 3 filters (1) ( 'col_AT Resolution' = "Resolution" ) AND ( 'Attachment' = $NULL$ ) (2) ( 'col_AT Resolution' = "Resolution" ) AND ( 'Attachment1' = $NULL$ ) (3) ( 'col_AT Resolution' = "Resolution" ) AND ( 'Attachment2' = $NULL$ ) As mentioned, it appears the filter guide is NOT walking the table, but in the example above, it does skip the first two records (as they are NOT marked as Resolution), but once it hits the 1st record that matches the Run if, it sets all three attachments fields with the one record. Thanks, Doug DISCLAIMER Important! This message is intended for the above named person(s) only and is CONFIDENTIAL AND PROPRIETARY. If you are not the intended recipient of this e-mail and have received it in error, please immediately notify the sender by return email and then delete it from your mailbox. This message may be protected by the attorney-client privilege and/or work product doctrine. Accessing, copying, disseminating or re-using any of the information contained in this e-mail by anyone other than the intended recipient is strictly prohibited. Finally, you should check this email and any attachments for the presence of viruses, as the sender accepts no liability for any damage caused by any virus transmitted by this email. Thank you. __20060125_______________________This posting was submitted with HTML in it___ __20060125_______________________This posting was submitted with HTML in it___ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
<<inline: image001.jpg>>
