Versions Compared

Version Old Version 4 New Version Current
Changes made by

Products Admin

Products Admin

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

Overview

  • Query Records is a Workflow Action, which an important workflow action for the CRUD operations

  • Query Records is used to fetch or retrieve the values from fieldsrecords

  • Query Records can be fetched or retrieved from

  • Object

  • Model

    • Variable

    performed using source type Object, Model and Variable

Attributes

Config

  • Source Type: Select the The source type , there is from which where you want to retrieve the data. There are three sources

    • Object

    • Model

    • Variable

  • Based on your Object: If you select the source type select your either Object, Variable, or Modelas 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 select the radio button the following fields are visible

    • Single: Select this button if you want to retrieve a single

    or multiple records.Fields: Select the fields which

    • 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 fieldsFilters: Add filters to retrieve

    • 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: Specify 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

    Limit: You can specify the limit to query 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

...

  • Click On Save

  • Return to the Layout Page

...