SOQL Optimizer

Introduction

The SOQL Optimizer is a field that can help narrow down and focus the filter results. It is designed to work around the SFDC limitation around query limits. Filter logic may be too broad and return too many results. If the filter target has too many data records to sort through, an error message is returned that too many records were found.

That is where the SOQL Optimizer comes in. Using additional filter logic, the optimizer runs first and can take the data expression originally set and pre-filter those results. Only the records containing in the results search are shown. The SOQL Optimizer can be configured as part of the SObject component.

Where Can the SOQL Optimizer Be Used?

The SOQL Optimizer is a setting on the SObject component and the SObject look-up allows the user to pull records from the DataGuide form from any Salesforce SObject. The SObject must be related to the object that the form is built for.

How Can I Use the SOQL Optimizer?

Here are some common examples of using the SOQL Optimizer:

  • If a job has many activity records, con filter can display all of them. Using the optimizer can filter down to show just the activity records for that job, instead of all of them.