Currently am making two calls to salesforce API to fetch the data, below are the two queries:
1>SELECT PermissionSetAssignment.AssigneeId,PermissionSetAssignment.PermissionSet.Name FROM PermissionSetAssignment where PermissionSetAssignment.PermissionSet.IsOwnedByProfile=false order by PermissionSetAssignment.AssigneeId
2>SELECT UserOrGroupId,Group.Name FROM GroupMember order by UserOrGroupId
Can we have a single query instead of two?
Please help Salesforce GURU's.
If you have a relation between these tables you can directly fetch the UserOrGroupId in the first query itself