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'
Hi Julie,I believe above eQL should work, all you need to do is to enable the checkbox at the end of the report for combine duplicate records as shown below:
As you can see multiple properties separated by Pipeline under section "Attendees". It should work the same for File name as well.Please let me know how it goes.
Answer Verified By: julie_beck
That worked great, cheers Manav. Hope you are well
Awesome - I am all well and hope the same for you!