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!!!

5 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