9

I know how to query all the attachments related to the opportunity, but how to do the same for files attached. Seems like a file is a part of a content library.

Improve this question
4
  • Are these chatter files? If so, this related question should provide a solution for you.
    – battery.cord
    Jun 3 '16 at 18:50
  • No, I'm asking about Files. You can attach files using Lightning experience
    – Mike Raven
    Jun 3 '16 at 21:24
  • Solved. The file is actually a content document and could be easily obtained via foreign key: SELECT ContentDocumentId FROM ContentDocumentLink WHERE LinkedEntityId = '<Opportunity or other object id here>'
    – Mike Raven
    Jun 3 '16 at 23:04
  • 2
    Can you add your comment as an answer and mark it as best answer, as it might help other users in the future with the same question.
    – Jenny B
    Jun 4 '16 at 19:49
16

Solved. The file is actually a content document and could be easily obtained via foreign key: 

SELECT ContentDocumentId FROM ContentDocumentLink WHERE LinkedEntityId = '<Opportunity or other object id here>'
Improve this answer
0

SELECT ContentDocumentId, linkedEntityId FROM ContentDocumentLink WHERE LinkedEntityId = "123"

ContentDocumentId = a salesforce object Id where this file is being used , linkedEntityId = id of the stored file

Improve this answer
2
  • How is that different from accepted answer?
    – kurunve
    Jun 16 '20 at 15:41
  • the query is the same. Just aadded the info about ContentDocumentId and linkedEntityId
    – Luís Aguiar
    Jun 22 '20 at 9:18

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.