Sharing cases with subset of Account contacts for Community Users

Question

Use Case

1. Account Contacts have a Field For Department
2. Case OWD set to Private
3. No Sharing Set

** Need to be able to provide access to a case created by a contact ONLY with other contacts on the same account with the same department. **

Sharing sets are an all or nothing. Case Teams Do not work There is no ability for Apex Sharing for Community Users.

My only thought is using visual force to override everything.

Does anyone have any workarounds that they can think of?

Answer 1

I created a trigger to share my cases, this may or may not help you, This will share the case to the partner user that created it, along with the group he is in

trigger PartnerCaseSharing on Case (after insert, after update) {

    Map<id,User>PartnerUsermap = new Map<id,user>([select id,UserType from user where UserType = 'PowerPartner' and isActive = true] );     
    List<GroupMember>GroupMemberList = new List<GroupMember>([select GroupId,UserOrGroupId from GroupMember]); 
    List<CaseShare> CsShareList = new list<CaseShare>();


    if(!PartnerUsermap.isEmpty()){
         for(Case cs : trigger.new){ 
                if(PartnerUsermap.containsKey(cs.CreatedById)){
                    for(GroupMember grpmem : GroupMemberList){
                        if(grpmem.UserOrGroupId == cs.CreatedById){   
                            CaseShare  csshare = new CaseShare (CaseId = cs.id,UserOrGroupId = grpmem.GroupId,CaseAccessLevel = 'Edit');                         
                            CsShareList.add(csshare);                         
                        }
                    }
                }
            } 
       }
    if(!CsShareList.isEmpty()){
        Database.SaveResult[] lsr = Database.insert(CsShareList,false);           
        Integer i=0;
        for(Database.SaveResult sr : lsr){
            if(!sr.isSuccess()){ 
                Database.Error err = sr.getErrors()[0]; 
                if(!(err.getStatusCode() == StatusCode.FIELD_FILTER_VALIDATION_EXCEPTION  
                                               &&  err.getMessage().contains('AccessLevel'))){

                    trigger.newMap.get(CsShareList[i].CaseId).
                      addError(
                       'Unable to grant sharing access due to following exception: '
                       + err.getMessage());
                }
            }
            i++;
        }  
    } 
}

Answer 2

Case Teams Do not work There is no ability for Apex Sharing for Community Users.

Why Case team does not work ?

A community user is actually associated to a contact, therefor in case team you don't have to add your community user as a case team member, but you have to search for his contact

Answer 3

I just stumbled upon this question and it might be late to answer it now. But you could still use Sharing Set and a trigger to achieve that. Sharing sets work with custom Lookup fields as well. So, you could create a custom Lookup(Contact) field on case. Hide that field from the layout. In the sharing set, match user's contact with this new field on case to provide access. Now, within a trigger on case, you could write your business logic to update the lookup field depending upon whether the current contact on the case needs access or not.