Execute Query

The Execute Query workflow action allows you to execute a predefined query and handle its results dynamically. When this action is used, it runs the selected query and makes its outputs available within a specialized container in your workflow.

Inside the Execute Query container, you can add additional workflow actions to process or manipulate the data returned by the query. The system will automatically iterate over the results, executing the specified actions for each result. This setup lets you efficiently handle and act upon the data retrieved by the query.

Key Configuration Fields

• Name

  • Enter a unique name for this workflow action.

  • Validation Rules:

    1. The name must be unique.

    2. The name length must be between 2 and 100 characters.

    3. The name cannot be empty.

    4. The name cannot include special characters, or spaces, or start with a numeric character.

• Query

  • Select the query from a list of all available queries in the system.

  • Validation Rules:

    1. The query field cannot be empty.

• Inputs Mapping Table

  • Mapping Table:

    • After selecting the query, a mapping table appears with two columns: Input and Value.

    • Input Column: Lists the inputs required by the selected query.

    • Value Column: Provides a dynamic field for specifying values for each input.

    • Validation Rules:

      • Non-nullable inputs must be provided with a value.

      • Nullable inputs can be left empty.

• Continue on Error (Optional)

  • A toggle that lets the workflow continue even if an error occurs during query execution. When set to True, the workflow will bypass the error and proceed without pausing.

Behavior After Configuration

• The system retrieves the query’s results and makes them available for further processing.

The query’s outputs are only available within the context of the Execute Query container. They cannot be accessed outside of this container.

• Processing Data within the Query Container:

  • You can add additional workflow actions inside the Execute Query container to process the data returned by the query.

  • The system automatically iterates over each result returned by the query, executing the specified steps within the container for each result.

  • This allows you to perform operations or apply further steps on each item of the query results.

Editing the Execute Query Action

• Fields

  • Always Disabled: Name field

  • Always Editable: Description field, Continue on Error toggle, Inputs Mapping Table

  • Disabled Once Used or Referenced in Another Workflow Action: Query field