Skip to end of metadata
Go to start of metadata

You are viewing an old version of this content. View the current version.

Compare with Current View Version History

« Previous Version 8 Next »

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

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

  • No labels