Loading
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 Simple Editor

          Create SOQL Filter Condition Using Simple Editor

          Use the Simple Editor to build basic SOQL filter conditions for object data. The Simple Editor guides you through assembling condition logic and supports dynamic variables.

          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 Simple Editor, click Add Condition.
          2. Complete the fields for the condition.
            1. Select a field.
            2. Select an operator.
            3. Select the value type: string to enter a value directly, or variable to retrieve context-specific data.
            4. Enter a value for the condition.
              Make sure strings and IDs are enclosed in single quotes.
          3. If required, add more conditions.
          4. Select a logical operator for the condition.
            • All of the conditions are met (AND)
            • Any of the conditions are met (OR)
            • Customize the logic (for example, 1 OR 2 AND 3)
          5. Click Add SOQL Expression.
          6. Save your changes.
           
          Loading
          Salesforce Help | Article