Querying all the files from a list of groups for a particualr user

Question

I'm trying to display all the files of all the Groups to which a user belongs to.

i.e, if the user is a member of GroupA and GroupB, then I have to display all the files which belong to GroupA and all the files which belong to GroupB.

This is similar to 'FILES IN MY GROUPS' section in the standard Files tab.

Currently I am trying to use the 'ContentDocumentLink' object as shown below:

select Id, ContentDocument.title, ContentDocument.LastViewedDate, ContentDocumentId, ContentDocument.LastModifiedDate from ContentDocumentLink where LinkedEntityId =:groupId

Using the above query I can get all the files which belong to the group referred by the groupId variable.

When I try to query by giving a set of ids for 'LinkedEntityId' field in the where condition, then I'm getting an error saying that only a single id, ContentDocumentid or LinkedEntityId should be used with an equals operator.

Is there any other object that can be used for this? Or should the above query be changed? So how can I get a list of documents which belong to a list of groups? Need some help on this please.

Answer 1

If groupId is defined as set<Id> or list<Id>, then you should be able to use WHERE LinkedEntityId IN :groupId for the WHERE clause in your query to resolve the error message you're receiving.

Answer 2

The following code works fine and it gives all the files posted in all the Groups the user is associated with:

public List lstCollaborationGroupFeed {get;set;}

public List lstCollaborationGroupMember{get;set;}

/* Find all groups containing logged in user*/

    lstCollaborationGroupMember = [SELECT CollaborationGroup.Id, CollaborationGroup.Name FROM CollaborationGroupMember WHERE MemberId = :UserInfo.getUserId()];

    Set<Id> setMemberId = new Set<Id>();
    for(CollaborationGroupMember member : lstCollaborationGroupMember )
    {
        setMemberId.add(member.CollaborationGroup.Id);
    }

    lstCollaborationGroupFeed = [SELECT Title, ContentFileName, RelatedRecordId FROM CollaborationGroupFeed WHERE Type='ContentPost' AND ParentId IN :setMemberId];

lstCollaborationGroupFeed returns the details of all the files posted in the User's Groups.