SharpenDB DELETE Panel

Overview

The SharpenDB DELETE panel executes a DELETE query against a custom table in SharpenDB, removing records that match the conditions you define. It is used to keep your database clean and relevant by eliminating outdated or resolved records as part of an automated Logic+ flow.

Before You Begin

DELETE queries are permanent. Before going live, use the Test feature within the panel to validate that your conditions are filtering the correct records. A misconfigured Where clause could delete more records than intended.

Example Use Case

A Logic+ flow handles inbound support calls. When a caller confirms that their issue has been resolved, the flow triggers the SharpenDB DELETE panel to remove the corresponding ticket record from the database. This keeps the database free of stale resolved records and ensures that only active, relevant entries are retained.

Properties

• Name

  • Enter a unique, descriptive name to identify the panel.

• Description

  • Enter any notes about the panel for reference. This field is collapsed by default; select the down arrow to expand it.

• Initiates Flow

  • Designates this panel as the starting point of the Logic flow. When selected, this panel will be the first to execute when the flow is triggered. This can only be removed by setting a different panel as the flow initiator.

• Redact Data in Logging

  • Disables data logging for this panel to support data redaction requirements. This feature is available upon request and is subject to change.

Test

Use the Test feature to run the configured query and verify it behaves as expected before the flow goes live. Results can be viewed in two formats:

• View JSON: Displays the query results as a structured JSON object.

• View Table: Displays the query results in a tabular format for easier readability.

Fields

• Table

  • Select the SharpenDB table from which records should be deleted.

    • Use Dropdown: Select from existing tables in the environment.

    • Use Variable: Reference a variable containing a string that matches an existing SharpenDB table name.

• Where

  • Define one or more conditions to filter which records are deleted. Only records that match the specified conditions will be affected. Each condition consists of the following:

    • Field

      • Use Dropdown: Select from the available fields in the selected table.

      • Use Variable: Reference a variable containing a string that matches an existing field name in the table.

    • Operator

      • Select the comparison operator to apply to the condition. Available options are in the table below.

    • Value

      • Enter the value to compare against the selected field.

• Where Operator

  • Select how multiple Where conditions are combined when more than one is defined.

    • AND: All conditions must be true for a record to be deleted.

    • OR: Records matching any one of the conditions will be deleted.

• Variables

  • Save variables from the data returned from a table.

    • Name: The variable where the JSON Path data returned is stored.

    • JSON Path: The path of the data returned.

• Timeout

  • Specify the number of seconds to wait for the query to return a result before timing out. If the timeout is reached, the flow will route through the Timeout exit path.

    • Use Dropdown: Select a numerical value from the available options.

    • Use Variable: Reference a variable containing a numerical value.

Exits

• Default

  • The path taken when the DELETE query executes successfully.

• Timeout

  • The path taken if the query does not complete within the specified timeout period, typically due to a slow or non-performant query.

Related Articles

• SharpenDB INSERT Panel

• SharpenDB SELECT Panel

• SharpenDB UPDATE Panel

• Available Predefined Variables

• Set Variable Panel [internal Confluence reference, not migrated in this run]