...
Config Field | Description | |||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|
Source Type | In this optiondropdown, you can select a source among various sources from which you want to query records. It allows to choose from Object, Model and Variable. Info | Note:
Info |
| |||||||||
Object | In this option, you can select the object from which you want to query records. The chosen object will define the source of data for your query | |||||||||||
How many records to store? | In this option, you can select amount specify the number of records to query . Either you can choose Single or Multi-recordfrom the selected object. You can choose to retrieve either a single record or multiple records based on your operational needs.
| |||||||||||
Fields | In this option, you can see view and select fields from the object you selected which have previously chosen. These fields represent the data points within the object that you can query for. infoNote: This will be blank, if no object is chosen. | |||||||||||
Selected Fields | In this option, you can see selected fields by you which are querying for. | |||||||||||
Filters | It This option enables user to filter out the data for records data from the selected object using AND and OR logical operators. These operators allow the user to create complex logic for querying records, ensuring that only the relevant data is retrieved.
| |||||||||||
Order By |
| |||||||||||
Limit | It is used to specify the number of records to be queried in single query. | |||||||||||
Offset | To efficiently manage large result sets in a SOQL query, use the
|
Filters
Custom Logic for Multiple Filters
Additionally, you can add multiple filter conditions and define custom logic for how they should be evaluated.
AND: Provide results If all provided conditions are true
OR: Provide results If one of the provided conditions are true
...
Condition | Description |
---|---|
Add Condition |
|
Add Group Condition |
|
Value Configurations
In this section, provide a value to compare or check against the selected field. You can provide a value by clicking on the gear icon. It opens up a screen to provide value using merge text.
Info |
---|
Reference: Merge Text |
...
Include Page | ||||
---|---|---|---|---|
|
Panel | ||||||||
---|---|---|---|---|---|---|---|---|
| ||||||||
For example, you can set the |
...
Order By
...
Order By Attributes | Description |
---|---|
Field Name | Here user can select the object field. |
Sort As | Here, you can sort the fields in either Ascending Order or Descending Order. |
...
Include Page | ||||
---|---|---|---|---|
|
Panel | ||||||||
---|---|---|---|---|---|---|---|---|
| ||||||||
For example, if an online delivery platform wants to separate records of clients named |