Skip to main content

Hi,

 

Could you please help me how create a single SOQL query for fetching : User Id, User NAME, User Profile Name, user using Permission set license name in a single SOQL Query.

I am using below query which does execute but under Assignee.Profile.Name field I get wrong output. [screenshot attached]

 

Could you please let me know how can I correct this Query to get correct profile name

 

#SOQL Queries #SOQL Query #REST API #Salesforce Developer #User Profile #Permission Set #Sales Cloud #Integration.

 

Query : SELECT Assignee.Id, Assignee.Name, Assignee.Alias, Assignee.ProfileId, Assignee.Profile.Name, PermissionSetLicense.MasterLabel FROM PermissionSetLicenseAssign

 

Thank you!!

2 个回答
  1. 2021年10月11日 05:44

    This is correct, just use this query in the SALESFORCE INSPECTOR Data Export Tab. It will show there.

     

    IT will show like this:

    This is correct, just use this query in the SALESFORCE INSPECTOR Data Export Tab. It will show there.

0/9000