Loading
Salesforce now sends email only from verified domains. Read More
Help Agent Performance DegradationRead More
Table of Contents
Select Filters

          No results
          No results
          Here are some search tips

          Check the spelling of your keywords.
          Use more general search terms.
          Select fewer filters to broaden your search.

          Search all of Salesforce Help
          Create SOQL Filter Condition Using Advanced Editor

          Create SOQL Filter Condition Using Advanced Editor

          Use the Advanced Editor to create SOQL filter conditions for object data by directly typing your filter logic. The Advanced Editor also supports dynamic variables and enables you to test your SOQL condition before saving.

          Required Editions

          Available in: Lightning Experience
          Available in: Enterprise and Unlimited Editions with Life Sciences Cloud, Life Sciences Cloud for Customer Engagement Add-on license, and the Life Sciences Customer Engagement managed package.
          User Permissions Needed
          To create filter conditions: Life Sciences Commercial Admin permission set
          1. In the SOQL Filter Condition field of the Object Metadata Cache Configuration record, under Advanced Editor, enter the SOQL query.
            Make sure strings and IDs are enclosed in single quotes.
          2. From the Insert dropdown, select a variable to insert in the SOQL query.
          3. To test the SOQL query, click Test SOQL.
          4. Save your changes.
           
          Loading
          Salesforce Help | Article