Query to fetch Role name and Profile Name of record Owner

SOQL:

SELECT Name, Owner.Name, Owner.UserRole.Name, Owner.Profile.Name FROM Account

Output:




Cheers!!!

7 comments:

  1. hi mulgan if i write the above mentioned query it shows an error, it was not executing the Error is "Parent relationship queries are disabled in Workbench: Owner.Name". So please send correct query.

    ReplyDelete
    Replies
    1. Workbench doesn't support this. Use force.com explorer.

      Cheers!

      Delete
    2. Then why are you tested it by work bench(if you don't mind), is there any specific reason......?

      Delete
    3. Go to the workbench setting and in the Query & Search option click on the check box "Allows SOQL Parent Relationship Queries" and click on apply setting.
      You will be able to access the parent relationship queries.

      Delete
  2. This was very helpful. I needed to use Data loader to extract Accounts for 4 User roles. This info helped me create:
    Select Id,Name,OwnerId FROM Account WHERE Owner.UserRole.Id IN('00E90000001ZHwfEAG','00E90000001ZHwkEAG','00E90000000Qfy2EAC','00E90000000Qfy7EAC')

    ReplyDelete
  3. Can you get this to show the profile name of the owner of an opportunity? I was not able to find the owner.profile.name when searching for field options in workbench

    ReplyDelete
    Replies
    1. Try this query: SELECT Name, Owner.Name, Owner.UserRole.Name, Owner.Profile.Name FROM Opportunity in workbench. Don't look for fields as they are related fields.

      Delete