One of our founders, Glenn Weinstein, authored a fantastic utility a few years back that allows for any admin to run and test SOQL queries from within their Salesforce org... right from a custom tab! We recently converted the SOQL Query tool to Visualforce and thought we'd share it with the community. It's on the Force.com code share and is available to everyone.
We added some new features, including desc and select *
We have a toolbox of useful utilities we use to quickly show value and get a jump on projects. The SOQL Query Tool has been on of the key ones the past few years. We're looking forward to your feedback.
If you want to download a read-only version from your SVN client, you can run the following command:
svn checkout http://soql-query-tool.googlecode.com/svn/trunk/ soql-query-tool-read-only


Appirio's Tech Blog


2 comments:
Great tool! There is one limitation ... the query output is incorrect when there are lookup fields retrieved which do not have results. For example, the following query would produce incorrect output when the account field on contact is not populated:
"SELECT id, lastname, firstname, account.id, account.name, ownerId FROM contact LIMIT 10"
Forgive my ignorance but I'm new to Saleforce and visualforce development. How would do I go about installing the above tool? more so the visualforce page.
Post a Comment