...
Query Records is an important workflow action for the CRUD operations
Query Records is used to fetch the records
There are three source types from which you can retrieve the records
Object
Model
Variable
Query Records can be performed using source type Object, Model and Variable
Attributes
Config
Source Type: The source type is from which where you want to retrieve the data. There are three sources
Object
Model
Variable
Object: If you select the source type as Object, then this field is visible where you can select the object from which you can retrieve the record
How many records to store: If you select the source type as Object, then the following fields are visible
Single: Select this button if you want to retrieve a single record
Multirecord: Select this button if you want to retrieve the more than one record
Fields: When you select the Object from the Object field. This will display all fields which are present on that object this also contains the nested fields
Nested Fields: Nested fields are nothing but the fields that contain related fields inside it
Filters: A filter is used to query the particular records
Order By: Order By lets you display the order of the record by Field name For e.g: Ascending or Descending
Field Name: Field name lets you select the available fields from that object to display the records by that field name
Sort By: Sort by is used to specify the Order to display the record by Ascending to Descending.
Limit: Limit is the maximum number of records that you query or retrieve the record for e.g: 10 or 200
Offset: This field displays the record from the below-entered value for example: If you enter the value 5. It will display the record from below 5 records.
...