Ask AI
Skip to main content

Delete from ext. database

Function: Delete from ext. database​

This action allows you to remove one or more entries (records) from a table in an external database that is connected to your platform. You can specify which records to delete by setting up filters based on the data within those records.

Input​

  • Database connection: This is the link to your external database. You'll select the specific database connection you've already set up in your platform.
  • Table: The name of the specific table within your connected database from which you want to delete records.
  • Data format: This defines the structure of the data in the chosen table. It helps the platform understand what kind of information is stored in each column.
  • Filters: (Optional) This allows you to specify conditions to decide which records should be deleted. If you don't set any filters, all records in the specified table will be deleted.
    • Attribute: Choose a specific column (attribute) from your table that you want to check.
    • Operator: Select how the chosen attribute should be compared to a value. For example, "Equal to", "Greater than", "Contains", etc.
      • Equal: The attribute's value must be exactly the same as your specified value.
      • Greater than: The attribute's value must be numerically or chronologically larger than your specified value.
      • Greater than or equal: The attribute's value must be numerically or chronologically larger than or equal to your specified value.
      • In: The attribute's value must be one of a list of specified values.
      • Less than: The attribute's value must be numerically or chronologically smaller than your specified value.
      • Less than or equal: The attribute's value must be numerically or chronologically smaller than or equal to your specified value.
      • Not equal: The attribute's value must not be the same as your specified value.
      • Not in: The attribute's value must not be one of a list of specified values.
      • Contains: The attribute's text value must include your specified text.
      • Contains \(ignore case\): Similar to 'Contains', but doesn't differentiate between uppercase and lowercase letters.
      • Starts with: The attribute's text value must begin with your specified text.
      • Ends with: The attribute's text value must end with your specified text.
    • Value: The specific data you want to compare against the chosen attribute using the selected operator.

Output​

This action performs a deletion operation and does not return any specific data. The outcome is the removal of records from your external database.

Execution Flow​

Real-Life Examples​

  1. Deleting an old customer record:

    • Inputs:
      • Database connection: MyCRM_Database
      • Table: Customers
      • Data format: Customer_Schema
      • Filters:
        • Attribute: CustomerID
        • Operator: Equal
        • Value: 12345
    • Result: The customer record with CustomerID 12345 is permanently removed from the Customers table in MyCRM_Database.

  2. Removing all pending tasks older than a specific date:

    • Inputs:
      • Database connection: ProjectManagement_DB
      • Table: Tasks
      • Data format: Task_Schema
      • Filters:
        • Attribute: Status
        • Operator: Equal
        • Value: Pending
        • (Add another filter)
        • Attribute: DueDate
        • Operator: Less than
        • Value: 2023-01-01
    • Result: All tasks in the Tasks table that have a Status of Pending AND a DueDate before January 1, 2023, are deleted from ProjectManagement_DB.

  3. Clearing out temporary log entries from a specific application:

    • Inputs:
      • Database connection: ApplicationLogs_DB
      • Table: LogEntries
      • Data format: LogEntry_Schema
      • Filters:
        • Attribute: ApplicationName
        • Operator: Equal
        • Value: TemporaryDataProcessor
        • (Add another filter)
        • Attribute: LogType
        • Operator: Starts with
        • Value: TEMP_
    • Result: All log entries in the LogEntries table where the ApplicationName is TemporaryDataProcessor AND the LogType starts with TEMP_ are removed from ApplicationLogs_DB.