I have a SOQL query that I am able to run in eclipse, developer console and the workbench (as a list).
Here is my query. The query is based on two standard objects - User and UserRole.
Select u.Name, u.Id, (Select Username, LastName, FirstName, Name, IsActive From Users) From UserRole u WHERE u.name like 'Inside%'
When I select the "Bulk Csv" option in the workbench, I get this error.
Invalid Job: Unable to find object: users
How can I download the results to a csv file?
The workaround I have is:
- Select the List Option.
- Save the results page as an HTML page on my laptop.
- Copy the contents of an HTML page to Excel.
- Edit the excel spreadsheet and save.
Is there a better (free) alternative to do this?