SOQL 2 Report - Create data exports and reports based on a SOQL query

Highlights

• Key features:
  - Create a CSV report based from a SOQL query. - Batch process reports; generate multiple reports in bulk with a single click with batch process button. - Create and maintain data export jobs for backup or migration purposes.
• - Export data from Salesforce objects including formula fields without access to workbench or external tool.
  - Save time in creating reports, quickly generate a complex reports with joins/child records using soql.
• - Easily share generated reports internally or externally of Salesforce organization.
  - Export upto 50 million records. - 100% native to Salesforce - Supports Classic and Lightning platform no software required.

What SOQL 2 Report - Create data exports and reports based on a SOQL query does

Bridge the gap between declarative and programmatic efforts, SOQL2Report app is a tool to convert SOQL query into a csv report.

The installation is quick and application is easy to use, runs natively within Salesforce.

Use Cases:

------------

Excellent for complex reports where the Custom Report Types are not good enough, for example for queries that use Objects not available for Reporting for example: SetupAuditTrail, multiple joins between objects, the NOT IN clause in selection criteria etc...

Exporting all the data from Salesforce including formula fields without accessing external tool like workbench.

Maintain data backups for disaster management.

Export seed data for sandbox orgs.

Save time in creating reports, quickly generate joined report containing joins/child records using subquery in SOQL.

All child records of a parent can generated by adding subquery to the soql.

For example: following is a query to select all contacts under a contact: select id, name, (select name from contacts) from account.

Screenshots