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 1. Request ID (Field 1) 2. Instance ID of the Parent 3. A true attachment Field 4. 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 __20060125_______________________This posting was submitted with HTML in it___ 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. _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
<<image001.jpg>>
