You want to browse through the fields,
attributes, and relationships of every object in your Salesforce.com organization,
and you're on the Mac OS X platform.
users, SoqlXplorer provides metadata exploration, a SOQL query tester,
and a graphical schema view for examining object relationships (a
piece of functionality that's only available on the Mac OS X platform!).
Download SoqlXplorer from Simon Fell's PocketSOAP website at www.pocketsoap.com/osx/soqlx. After the download automatically extracts itself, drag the
SoqlXplorer icon to your Applications folder to complete the installation.
After installing SoqlXplorer, open the application and log
in by entering your standard Salesforce.com username
and password and specifying the server to which you want to connect.
Choose www.salesforce.com to connect to the normal production servers,
or test.salesforce.com to connect to a sandbox organization.
After you click Login, SoqlXplorer issues
a describeGlobal() call to the API to
populate the interactive list of objects in the right sidebar.
You can expand any object to explore
its fields and relationships. To view attributes for an object, toggle
the Details button to On in the bottom right
corner of the window. If you select an object field, the Details popup shows properties for the field instead.
Attributes in SoqlXplorer
Two views are available in the main window: SOQL and Schema.
Schema View in
- Use SOQL view to open a SOQL query editor
where you can construct and execute SOQL queries. The queries you
write use syntax-highlighting to improve legibility, and you can double-click
an object's name to automatically build a query that selects all available
fields. You can also double-click any result data to copy and paste
- Use Schema view to open an interactive
entity relationship diagram (ERD) of the objects in your organization.
Select any object in the right sidebar to view that object's parent
relationships (in blue) and child relationships (in orange). You can
expand the fields of any object by clicking the + toggle button in the upper right corner of any object, and you can
double-click an object to move it to the center of the view.