Query all Content Notes of an opportunity

Question

How would I query the ContentNotes of an opportunity? I'm able to query all the ContentDocumentLink and able to get the ContentDocument but the ContentDocument does not have the fields that I'm looking for, mainly body or content.

Answer 1

The link between ContentNote and any related record is stored in the ContentDocumentLink. So, if you're writing a trigger or Executing Anonymous Code, you need to query all ContentDocumentLinks related to your Opportunity. So, something like this:

Map<Id,List<ContentNote>> noteMap = new Map<Id,List<ContentNote>>();

    for(ContentDocumentLink links : [SELECT LinkedEntityId, ContentDocumentId FROM ContendDocumentLink WHERE LinkedEntityID = '006xxOppId']){
        List<ContentNote> notes = noteMap.get(links.LinkedEntityId);
        if(notes == null){
            notes = new List<ContentNote>();
            notes.add(links.ContentDocumentId);
            noteMap.put(links.LinkedEntityID, notes);
        }
        else{
            notes.add(links.ContentDocumentId);
        }

}

This gives you a map of all ContentNotes for whatever Opportunity it is that you're indicating. Then you could loop over the list to do whatever it is that you're wanting to do.

    for(ContentNote cn : noteMap.get('Enter your oppId here'){
      //do something with your note records
    }

Answer 2

You have to query ContentNote object. Here is the schema for ContentNote Objects: