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.
| Info |
|---|
Relevant information for configuring this panel can be found using Sharpen's public API documentation for SharpenDB. Your relevant isolation zone link IZ0 or IZ1 |
Using the panel
The "SharpenDB DELETE" panel empowers organizations to tailor interactions by accessing data stored in customizable SharpenDB tables. This allows each caller to experience a dynamic, personalized flow based on specific criteria retrieved from the database.
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.
