The Workbench is a community-contributed, web-based application that gives administrators and developers on-demand access to useful tools to manage salesforce.com organizations. Starting with a combination of the features of the Apex Data Loader, Force.com Explorer, and System Log, the Workbench can insert, upsert, update, query, search, delete, undelete, and purge data as well as describe any object or execute Apex scripts directly in your web browser. These functions build on the strengths of these existing products to create an even more powerful and easier-to-use on-demand application. Not only can the Workbench be used as a standalone application in your browser, but it can also be integrated within Salesforce as a single-sign-on web tab for more convenient access.
News
2009-06-21 Download Workbench 2.3.16 for Summer '09 Today
With Salesforce.com completing its Summer '09 roll out to production last week, it's time for Workbench to introduce its own set of exciting enhancements! Download Workbench 2.3.16 today to try out all these new features:
- Upgraded Partner and Apex clients to Force.com API 16.0
- Added support for parent-to-child SOQL relationship queries to display nested sObjects. For example, [SELECT Id, Name, (SELECT Id, LastName, FirstName FROM Contacts) FROM Account] will display Accounts with their child Contacts.
Now that relationship queries are available in both directions (parent-child and child-parent), you can leverage the combination of relationship and semi-joins to run queries such as [SELECT Name,(SELECT Contact.Name FROM OpportunityContactRoles) FROM Opportunity WHERE Id IN (SELECT OpportunityId FROM OpportunityContactRole)] to reach down to the Opportunity Contact Roles on all Opportunities that have Contacts associated to them and then display the Contact's names -- all without having to deal with Salesforce Ids!
- Added the ability to download full results history from file-based API operations. Similar to the success and error files produced by the Data Loader, but in one convenient file that can be downloaded on demand.
- Introduced optional Describe Results Highlighting for custom fields, system fields, and boolean values.
- Extended Link Ids to Record Detail feature across the entire application. Now, if a Salesforce Id appears anywhere from a query result to a Apex debug log to an upsert, it is automatically hyperlinked to the record detail in the Salesforce user interface. This feature can optionally be disabled.
- Added advanced login support for new Salesforce instances, including AP1 and CS5.
- Added additional set of buttons at top of Setting page for easier access.
- Corrected error if more than one Document or Attachment body is queried.
- Made Search results consistent with the rest of the application to start incrementing results at 1.
- Minor bug fixes to CSV preview.
News Archive
Statistics
