Query Records

Overview

• Query Records is an important workflow action for the CRUD operations

• Query Records is used to fetch the records

• 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.

Action Details

• Label: Label is used to identify the Query Records at UI

• Name: Name is the unique identifier of the modal

• Description: Description is some information about the workflow action

• Is Async?: If more than workflows are created and if the check box is checked then the workflows will execute one after one.

Input

• Label: Label is used to identify the Input Variable at UI

• Name: Name is the unique identifier of the Input Variable

• Field Type: Select the field type

• Required: If the checkbox is checked, then Input Variable Field will be required

• Is Array?: If the checkbox is checked, then Input Variable Field will be stored in an array

• Default Value: Specify the default value for the input variable

   

   

Query Records Creation

• Create a Workflow Workflows

• Drag and drop the Query Records

Open

Config: Query Records

Open

Config: Query Records

• Click On Save

• Return to the Layout Page