Search code examples
salesforcesoqlsalesforce-service-cloud

How can i merge two different queries using "Salesforce Object Query Language (SOQL)"?

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.

Solution

  • If you have a relation between these tables you can directly fetch the UserOrGroupId in the first query itself