7 Replies Latest reply on Jul 28, 2014 10:43 AM by philmodjunk

    How to create aggregate summary of a found set?

    guyscharf

      Title

      How to create aggregate summary of a found set?

      Post

           I have a found set that is a result of a series of complex scripted searches.  The set contains address records, and one of the fields of the record is an email address.

           I want to create a list() aggregate of email addresses in all the records in the found set.  I am not using a report format or portal, so it appears that the list() aggregate function won't help.  Is that true, or is there a way to apply it?

           I can of course loop through the found set and simply create a concatenated string that includes all the email addresses.

           But I wondered if there were a more clever solution?