eQL for Files.Name, returning one row per document where multiple files

Hi Bentley and the Forum,

I have a report that brings back the files on a set of documents. That works fine but where there are multiple files, it brings back 2 rows. I would ideally like one row per document with the Files.Name column concatenated with the names of the files with a comma or pipe or something. Can this be done in eQL at all? If so, how about SQL? I have been trying with COALESCE but no luck yet.

Many thanks,

Julie

START WITH Document
SELECT 
   Id,
   Code,
   Revision,
   Name,
   Class.Code,
    Files.Name 
WHERE 
   Code LIKE 'SAA3A%'
   AND IsLatestRevision = 'Y'

Parents Reply Children