Skip to main content

WorkFlow Notes

Workflow Templates Overview​

The Workflow Templates module provides predefined configurations for executing various data-related tasks efficiently and consistently across projects. These templates streamline common operations such as inserting, updating, deleting, querying, and managing data relationships.

Available Workflow Templates​

1. Data Add​

Add new records to a specified table, ensuring validation, uniqueness, and relational consistency.

  • Name: Name of the template.
  • Connections: Select the DB connection.
  • Table Selection: Target table for insertion.

2. Data Update​

Modify existing records in a controlled manner with parameter-based filters.

  • Name: Template name.
  • Connections: Choose a database.
  • Table Selection: Table to update.
  • Params: Define the fields and conditions.

3. Data Retrieval​

Fetch data with advanced filtering options for analysis or reporting.

  • Name: Retrieval operation name.
  • Connections: DB connection.
  • Table Selection: Target table.
  • Filters: Apply filters to narrow results.

4. Data Deletion​

Remove records using soft or hard delete operations, with filter conditions.

  • Name: Deletion template name.
  • Connections: DB connection.
  • Table Selection: Table for deletion.
  • Filters: Conditions to identify deletions.

5. SQL Query​

Execute raw SQL statements for advanced or non-standard operations.

  • Name: SQL query template name.
  • Connections: Select the database.
  • Query Selection: Choose predefined or custom SQL queries.

6. Visual Query​

Build database queries using a visual, code-free interface.

  • Name: Visual query name.
  • Connections: DB connection.
  • Query Selection: Select the visual query.

7. Stored Procedure​

Run stored procedures with support for parameter passing and result handling.

  • Name: Stored procedure template name.
  • Connections: Choose DB.
  • Stored Procedure Selection: Pick the procedure to execute.

8. Transaction Data​

Batch processing for inserts, updates, or deletes within a transactional scope.

  • Table Selection: Target table.
  • Transaction Type: Insert, Update, or Delete.
  • Filters: Apply for targeted operations.

9. Data Hierarchy​

Manage complex parent-child relationships across tables in hierarchical structures.

  • Master Table: Define the root table.
  • Operation Type: Select, Insert, Update, or Delete.
  • Filters: Define data operation scope.

These templates are designed to support both simple and advanced data workflows, enabling users to build reliable, maintainable systems while minimizing manual intervention.