SmallBuilder Help
AppExchangeContact Us
πŸ‡ΊπŸ‡Έ English
πŸ‡ΊπŸ‡Έ English
  • SmallBuilder Help
  • Getting started with SmallBuilder
    • License and Permission Set Assignment
    • Organization Currency Setup
    • Connected App Configuration
  • πŸ“¦SmallBuilder Line Items
    • Release Notes
      • '25 Update
        • v 1.38
        • v 1.37
    • SmallBuilder Line Items Overview
    • Getting Started
      • Assigning Licenses and Permissions
      • Organization Currency Setup
      • Connected App Setup
    • Builder
      • Getting Stared with the Builder
      • Default Setting
        • Responsive Screen Configuration for Devices
        • Adjusting Editor Screen Ratio
        • Modifying Editor Labels
        • Lookup Selector Settings
          • Search All on Load
          • Expand Filters by Default
          • Allow Select Duplicate Item
          • Caching to Improve Performance
          • Records Per Page
        • Line Item Editor Settings
          • Show Summary
          • Freeze First Column
      • Builder Setup Steps
        • Relate Objects
          • Parent Object
          • Line Item Object
            • Set Object and Parent Reference Field
            • Set Filters and Sorting for Saved Line Items
            • Control Line Item Deletion
            • Set Auto-Numbering
          • Lookup Object
            • Select Lookup Reference Field
            • Set Keyword Search
            • Block Lookup Selector
            • Set Filters and Sorting for Lookup Records
        • Setup Lookup Selector
          • Add Columns
          • Reorder Columns
          • Change Column Labels
          • Set Column Width
          • Change Text Alignment
          • Add Virtual Columns for DataSource
        • Setup Line Item Editor
          • Add Columns
          • Reorder Columns
          • Change Column Labels
          • Set Default Value
          • Source Field: Assigning Default Values from Parent or Lookup Fields
          • Set Column Width
          • Change Text Alignment
          • Set Field Input to Read-Only
          • Set Field Input as Required
          • Display Totals
          • Hidden Setting for Line Item Editor Columns
          • Exclude Certain Fields from Saving
        • Preview
        • Activate
        • Create Button and Add to Page Layout
      • DataSource
        • Basic DataSource: Retrieve Related Object Data
        • Advanced: Retrieve Data Using Apex Classes
      • Cloning the Builder
      • Resetting a Builder
      • Insert Filters Using the Query Wizard
      • Inserting Custom Labels into Editor Labels
    • Product Option
      • Product Option Setup Steps
        • Activate Product Options
        • Configure Product Options
          • Default Setting
          • Line Item Setting
        • Configure Product Option Data
      • Display and Storage of Line Item Option Values
    • Use Cases
      • Utilizing the Editor’s Aura Component
    • FAQ
  • πŸ“¦SmallBuilder Lists
    • SmallBuilder Lists Introduction
    • Getting Started with SmallBuilder Lists
      • Assigning Licenses and Permissions
      • Organization Currency Setup
      • Connected App Setup
    • Getting Started with Builder
    • Builder Setup Steps
      • Default Setup
        • Title
        • Legend
        • Allow Export
        • Allow Import
        • Show Icon
      • Datatable Setup
        • QUERY
        • Multi Selectable
        • Show Summary
        • Add and Edit Columns
          • Column Editing by Type
        • Add Virtual Column
        • Add Row Action
      • Data Import Setup
      • Action Setup
        • Add Action
      • Filter Setup
        • Add and Configure Filters
          • Filter Editing by Type
      • Compact Configurator Setup
        • Add and Configure Columns
          • Editing by Column Type
      • Mobile Setup
      • DataSource Setup
        • Basic DataSource
          • Add and Configure Actions
        • Advanced DataSource
          • Writing an Apex Class
      • List Deployment and Management
        • Creating a List Configurator Manually
  • πŸ“¦SmallBuilder Documents
    • SmallBuilder Documents Introduction
    • Quick start
    • Components
    • Data Merge
      • Data Merge - Text
      • Data Merge - Related List
    • Document Job
    • Basic usage examples
      • How to pin a logo image to the top of the page
      • How to leave a gap between the components
      • How to add separators between the components
    • Advanced usage examples
      • Creating an invoice template
      • Automatically email invoices with a trigger
    • FAQ
    • 🌟Release Note
      • '24 Update
        • v. 1.50 ~
  • πŸ“¦SmallBuilder Schedules
    • SmallBuilder Schedules Introduction
    • Quick start: creating a new Schedule configurator
    • Detailed setup guide
      • Basic settings (Side Panel)
      • Linked objects setup
      • Control Field setup
      • Schedule Object setup
      • Saving and activating
    • FAQ
  • ❓SmallBuilder Troubleshooting
    • SmallBuilder Troubleshooting Help
      • Add Button Warning (If the button is not added to the page)
      • Add Tab Warning (Tabs are created and added to the app, but not visible)
Powered by GitBook
On this page
  • Setting Up Logic
  • Binding Parent Object Fields to Filter Conditions

Was this helpful?

Export as PDF
  1. SmallBuilder Line Items
  2. Builder

Insert Filters Using the Query Wizard

PreviousResetting a BuilderNextInserting Custom Labels into Editor Labels

Last updated 4 months ago

Was this helpful?

The Query Wizard simplifies the process of setting up filters, especially for administrators unfamiliar with SOQL syntax. Instead of manually writing the WHERE clause in SOQL, admins can use an intuitive interface to select conditions and input values, making filter configuration much more accessible.

Filter Configuration in the Builder

Normally, filter settings in the builder correspond to the WHERE clause in SOQL. For administrators who are not well-versed in SOQL, this can be challenging. The Query Wizard resolves this issue by allowing admins to configure filters without needing in-depth knowledge of SOQL.

By using the Query Wizard, admins can define filter conditions through simple selection and input steps. This significantly streamlines the process of creating filters.

Setting Up Logic

When multiple filters are added in the Query Wizard, they are combined using AND logic by default.

Example: Adding Three Filters

When three filters are added using the Query Wizard:

These filters are combined into a single condition as follows:

1 AND 2 AND 3

Changing Logic

To modify the logic, click Edit Logic and customize the logic using the filter numbers.

Example: Changing All Conditions to OR

If you want to use OR instead of AND, edit the logic as follows:

1 OR 2 OR 3

The updated logic will generate filters based on the new condition.

Binding Parent Object Fields to Filter Conditions

Filters can also bind values to fields from the parent object. By selecting the Parent option next to the value input field, you can link the filter condition to a specific parent object field.

This feature enables dynamic data retrieval based on parent object field values, offering greater flexibility in query configurations.

Example: Filtering Pricebook Entries Matching the Parent Object's Pricebook

Let’s configure a filter to retrieve Pricebook Entries that match the parent object’s Pricebook (Pricebook2Id):

  1. In the Filter by Query section of the object connection step, click the Query Wizard button.

  2. Next to the value input field, select Parent.

  3. Search for and select the Pricebook field (Pricebook2Id) of the parent object.

  4. Confirm that the filter condition is automatically set to: {$Parent.Pricebook2Id}

This configuration ensures that only Pricebook Entries matching the parent object’s Pricebook are retrieved. The Query Wizard automatically generates the necessary filter syntax, making it easy and convenient to add conditions.

πŸ“¦
Query Wizard with three filters added
Generated logic with AND conditions

This example demonstrates the configuration of a Line Item Editor for Opportunity Products:

  • Parent: Opportunity

  • Line Item: OpportunityLineItem

  • Lookup: PricebookEntry