[SalesForce] Enable Query All Files permission

Just found out today that with the Spring 19' update there is a new setting in the "Setup -> Permission Sets -> (choose an existing or create a new one) -> App Permission -> Content -> Query All Files: Allows View All Data users to SOQL query all files in the org".

This is not enabled by default for the admin user but you can at least enable it in a Profile/Permissions Set.

Also, now documented in the API Documentation.

Have fun!

this is because you have Visibility as InternalUsers on ContentDocumentLink for each ContentDocument record, that represents lightning Files.

In order, to grant visibility access for Community users, you have to update Visibility to AllUsers for those files that should be visible to community users.

• AllUsers—The file is available to all users who have permission to see the file.
• InternalUsers—The file is available only to internal users who have permission to see the file.

Code to update all ContentDocumentLink records. If you don't have to do it for all Files, select only filtered records:

List<ContentDocumentLink> toUpdate = new List<ContentDocumentLink>();
for(ContentDocumentLink link : [
    select Id, Visibility
    from ContentDocumentLink
    where Visibility != 'AllUsers'
    ]){
    link.Visibility = 'AllUsers';
    toUpdate.add(link);
}
update toUpdate;