View Notes & Attachments in a Field Set

Question

My request is simple our client wants to have a link that opens/downloads files in a view.

The object has Notes and Attachments and I can add files to it no problem.

The idea I have with my primitive understanding of the framework is to make inside my Field Set a reference to the files inside Notes and Attachments by ID and visibly by the name associated with the attachment.

How would I go about making the Notes and Attachments visible in the Field Set? Is a Field Set the right way to do this?

The client wants to view many records at once. A nice way would be to give them access to get the associated files of many records in the existing list view. Optimally a hover to get a preview window would be great. . .

This must be a well known and previously solved problem.

Would I need to code a custom method inside the Field Set Controller to retrieve the Notes and Attachments? Or is there a handy wizard to do this? Or something else?

Answer 1

Heres a followup: Instead of trying to reference the IDs from the page it was much easier to add the attachments to the custom object itself using a wrapper class. This made the IDs available in the object itself

public class Records {
        public sObject obj {get; set;}
        public List<Attachment> attachments {get {
            List<Attachment> objAttachments = new List<Attachment>();       
            try
            {               
                objAttachments = [Select Id, Name, ContentType from Attachment where ParentId = :obj.Id];                                       
            }
            catch(exception ex)
            {           
                objAttachments = null;
            }
            return objAttachments;  
        } set;}
    }

    //Get all records
    public List<Records> getRecords() 
    {
        List<Records> records = new List<Records>();
        for (sObject obj : ssc.getRecords()) {
            Records record = new Records();
            record.obj = obj;
            records.add(record);
        }
        return records;
    }

Page:

        <apex:column headervalue="Attachments">
            <apex:repeat value="{!item.attachments}" var="image">
                <apex:outputlink value="/servlet/servlet.FileDownload?file={!image.Id}">"{!image.Name}"</apex:outputlink>
            </apex:repeat>
        </apex:column>