How to create aggregate summary of a found set?
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?