How to get the Sum of Length of Body Documents

Question

How can I get the sum of all the length of select Options document I only want the value of the Selected Documents.

docNames = new List<SelectOption>();   

for (Document d : [
    SELECT Id, Name , Body, BodyLength
    FROM Document
    WHERE (FolderId =: UserInfo.getUserId() OR FolderId =: '00lG0000001bBXb')
    AND ContentType = 'application/pdf'
]){
    docNames.add(
        new SelectOption(d.Id,d.Name + ' - ' + String.valueof(d.BodyLength) + ' bytes')
    );
    for (Integer i=0 ; i<= docNames.size() ; i++){
        docNames.BodyLength[i] ;
    }
}

Then I want do a try and catch so I dont let the user submit PDF files that sums up more than 5MB

try {
    if(d.BodyLength/1048576 >= 5) {
        ApexPages.addmessage(new ApexPages.message(
            ApexPages.severity.INFO,
            'The size of the file you are trying to upload is more than 5 MB. Please select another file.')
        );
        System.debug(' size > 5mb');
    }
}
catch(Exception pokemon){ // gotta catch em all!
    System.debug('ERROR:' + e);
}

Answer 1

It's a bit unclear what you are trying to do. It looks like you are building up a List of SelectOptions and then also trying to track the Body size of all those documents.

One likely cause of heap size issues here is retrieving the actual Body of the Document records in Apex when you only need to know the BodyLength.

Try something like:

List<SelectOption> docNames = new List<SelectOption>();
long totalBodyLength = 0;
Id exFolderId = '00lG0000001bBXb';

for (Document d : [SELECT Id, Name, BodyLength
                   FROM Document
                   WHERE (FolderId = :UserInfo.getUserId() OR FolderId = :exFolderId)
                       AND ContentType = 'application/pdf'] ){

    if(d.BodyLength >= 5 * 1048576) {
        // Exclude large documents that would exceed the Heap size
        // Could probably handle via the WHERE clause
        continue;
        // Note that in theory it should even be possible to create a Document > 5MB
    }

    docNames.add(
        new SelectOption(d.Id, d.Name + ' - ' + String.valueof(d.BodyLength) + ' bytes')
    );
    totalBodyLength += d.BodyLength;
}

Consider using Limits.getHeapSize() and Limits.getLimitHeapSize() to check for current and available heap. As Adrian comments, you won't be able to use the entire heap for the document body.