I have requirement like this,
Roles
Marketing
Sales
Finance
Record A role assigned Markrting and finance and Sales
Record B has Role assigned Markrting.
User A assigned to Markrting role of Record B and assigned to Sales Role of Record A
I want to query as below
Fetch all roles that User A has on Record B