Metaforce SOQL Explorer

If you are a Salesforce administrator or developer, you are probably familiar with SOQL. Many times we need to run SOQL queries to view detailed data in the database table for analysis and problem-solving, and some fields of the record may not be displayed on the layout.

So, how can you quickly build and run a SOQL query, and quickly view the returned data? This may be a problem we face every day.

The most direct way to create SOQL is through the Developer Console, where you can generate a SOQL query by selecting objects and fields and executing it. However, you have to consider some limitations:

• Manually selecting query objects, fields, and writing WHERE query statements
• Query results do not support querying up or down
• Batch operations are not supported
• SOQL query history is not easy to find

To improve query and processing efficiency, Metaforce SOQL Explorer provides a range of convenient and easy-to-use features that allow you to quickly create and query SOQL, as well as handle query results.

Metaforce SOQL Explorer

2 Query Modes

• Rest API Query: query salesforce standard/custom object records, such as Account, Contact, etc.
• Tooling API Query: query salesforce metadata object records, such as ApexClass, ApexTrigger, etc.

Object & Fields Selector

• By directly selecting objects and fields to be queried, you can quickly create SOQL query statements. As shown in the figure below, you can even quickly select cascading fields or directly add subquery statements!
• Then use the SOQL editor to add WHERE query conditions or directly modify the query statement. The SOQL editor provides auto-completion for fields or keywords, greatly improving the efficiency of writing SOQL queries.

View & Edit Records

After editing the SOQL statement, you can directly run it to view the query results.

• View cascading field values directly, such as Contact.Account.Owner.Name
• View child records returned via sub-query
• Edit, save, delete, or export records directly as a CSV file

Bulk updates via javascript

If you're familiar with javascript, you can easily write your own logic to populate values to the field on selected records as below.

It's useful if you need to bulk update a small volume of records without using data loader!

SOQL Execution History

If you'd like to explore more, feel free to visit our official website and documentation.

Website: https://metaforce.ltd/

Help Doc: https://docs.metaforce.ltd/