Hi Brad, You might actually need a join form to do this but here is how to get around the First Matching.
Create a Table field for the data source and fields you need. Create the character field Create a filter: Character field set field ($Character Field$ + Column1$) + "," (or other separator) Create a filter guide and add the filter you just created. Create a call guide and make sure to select loop table When Call Guide executed, the filter guide will use the filter to check each row of the table and set the result in the Character field. First time a created a guide function I did it with active links so I could see it. The only real difference is you need to have an active link to Change Field: Refresh Table before using the Call Guide Mark From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Brad Fike Sent: Tuesday, February 05, 2013 4:14 PM To: arslist@ARSLIST.ORG Subject: Returning SQL results as a single string. ** Hello Team, I have a have sql statement and i want to store the results in a character field during a filter set fields action not just 'Use First Matching Request' this is my example sql statement... select f.fieldName from arschema a, field f where a.schemaId = f.schemaId and a.resolvedName = 'User' and f.fieldName like 'L%' This is the best I've been able to come up with so far. It works from sql analyzer but not in the filter... DECLARE @Fields VARCHAR(8000) SELECT @Fields = COALESCE(@Fields + '; ', '') + f.fieldName from arschema a, field f where a.schemaId = f.schemaId and a.resolvedName = 'User' and f.fieldName like 'L%' SELECT @Fields as list Are there any SQL wizards out there? Thanks in advance. Thank You, Brad Fike (469) 759-0798<tel:%28469%29%20759-0798> b...@jbfike.com<mailto:b...@jbfike.com> _ARSlist: "Where the Answers Are" and have been for 20 years_ ________________________________ This e-mail is the property of NaviSite, Inc. It is intended only for the person or entity to which it is addressed and may contain information that is privileged, confidential, or otherwise protected from disclosure. Distribution or copying of this e-mail, or the information contained herein, to anyone other than the intended recipient is prohibited. _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers Are, and have been for 20 years"
