SharpenDB DELETE
- John Kargol
The "SharpenDB DELETE" panel is a powerful tool designed for users to execute DELETE queries on custom tables and data within SharpenDB. This feature allows users to effectively manage and remove outdated or unnecessary records, ensuring the integrity and relevance of their data. By utilizing this functionality, users can make informed decisions and maintain a streamlined database, ultimately enhancing the customer experience with up-to-date and engaging content.
Using the panel
The "SharpenDB DELETE" panel empowers organizations to enhance interactions by managing data stored in customizable SharpenDB tables. For example, in an IVR call flow, an organization may want to delete a record from the database after a successful resolution of a customer inquiry. For instance, if a caller contacts customer support to resolve an issue and a ticket is created in the system, once the issue is marked as resolved, the organization may choose to delete the corresponding record from the database. This helps maintain a clutter-free database and ensures that only relevant and active records are retained, improving overall data management.
Configuration
Set as Flow Initiator: Selecting "Set as Flow Initiator" designates this panel as the starting point of the IVR flow, initiating the sequence before progressing to subsequent panels within the Logic+ flow.
Panel Name: Choose a consistent name for the panel, and specify the variable to update. If the variable does not already exist, it will be created.
Panel Description: Provide a clear description detailing the panel's purpose and functionality. This acts as documentation, facilitating better understanding and identification of the panel's intended use by others.
Test: Evaluate the functionality of the configured query to ensure it performs as expected.
View JSON: Display the results of the query in JSON format for structured data analysis.
View Table: Present the query results in a tabular format for easy readability and comparison.
Table: Select an existing SharpenDB table to use and query
Use Dropdown: Select a table that exists in the environment.
Use Variable: A user-defined variable containing a string that matches a pre-existing SharpenDB table.
Where: It specifies conditions to filter records in a query, deleting only those that meet the defined criteria.
Field:
Use Dropdown: Selectable “fields” that exist in the selected SharpenDB table.
Use Variable: A user-defined variable containing a string that matches a pre-existing field in the SharpenDB table.
Operator: The operator is used when comparing the current variable against the specified comparison value.
Available Operators
= : Equal to!= : Not equal to> : Greater than< : Less than>= : Greater than or equal to<= : Less than or equal toIS / IS NOT : Checks if a value matches a specific condition, commonly used with TRUE, FALSE, or NULLLIKE / NOT LIKE : Performs pattern matching using wildcards (% for any number of characters, _ for a single character)IS NULL / IS NOT NULL : Checks if a value is NULL or not NULLIN : Matches any value within a specified listNOT IN : Ensures a value does not match any value within a specified listBETWEEN : Checks if a value is within a specified range (inclusive)NOT BETWEEN : Checks if a value is outside a specified range (inclusive)
Value: The value that is being compared against a selected field.
Where Operator: Select either "AND" or "OR" from the dropdown to define how multiple conditions are combined.
Timeout: Configurable amount of time, in seconds, to wait for the SharpenDB query to respond with a result set.
Use Dropdown: Specify a numerical value for when the time-out is met.
Use Variable: A user-defined variable containing a numerical value.
Exit Paths: Use the dropdown menu to select another panel in your flow. Any output from this panel will advance to the linked panel.
Default: The Default path is taken upon panel execution.
Timeout: The request time out was met, likely due to a non-performant query.
Related Article(s):