For one of my integrations project, I am trying to repurpose the Salesforce record sharing model outside Salesforce.
I have been following this article which talks about identifying access for user using join of following three tables: Object table example: Case, Object share table example: CaseShare and GroupMaintenance tables which I understand doesn't exist and I assume Salesforce creates dynamically using Roles, RolesandSubordinates and RolesSubordinatesInternal tables.
My problem is when I try to create this third groupmaintenance table myself and try to find members of groups of the type "RolesandSubordinates", I get zero results from GroupMember table. Reading the documentation of Salesforce, it says GroupMember will only return direct members of the group. Hence, I am unable to fetch members of groups of the type: roleandsubordinates.
Am I doing something wrong? Any help is much appreciated!!