SharpenDB UPDATE

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.

1. View JSON: Display the results of the query in JSON format for structured data analysis.

2. 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

1. Use Dropdown: Select a table that exists in the environment.

2. Use Variable: A user-defined variable containing a string that matches a pre-existing SharpenDB table.

Update Fields: Selectable fields/column names that exist in a SharpenDB table.

1. Fields:

   1. Use Dropdown: Selectable “fields” that exist in the selected SharpenDB table.

   2. Use Variable: A user-defined variable containing a string that matches a pre-existing field in the SharpenDB table.

2. Update Value: The updated value.

Where: It specifies conditions to filter records in a query, returning only those that meet the defined criteria.

1. Field:

   1. Use Dropdown: Selectable “fields” that exist in the selected SharpenDB table.

   2. Use Variable: A user-defined variable containing a string that matches a pre-existing field in the SharpenDB table.

2. Operator: The operator is used when comparing the current variable against the specified comparison value.

   1. Available Operators

      1. = : Equal to

      2. != : Not equal to

      3. > : Greater than

      4. < : Less than

      5. >= : Greater than or equal to

      6. <= : Less than or equal to

      7. IS / IS NOT : Checks if a value matches a specific condition, commonly used with TRUE, FALSE, or NULL

      8. LIKE / NOT LIKE : Performs pattern matching using wildcards (% for any number of characters, _ for a single character)

      9. IS NULL / IS NOT NULL : Checks if a value is NULL or not NULL

      10. IN : Matches any value within a specified list

      11. NOT IN : Ensures a value does not match any value within a specified list

      12. BETWEEN : Checks if a value is within a specified range (inclusive)

      13. NOT BETWEEN : Checks if a value is outside a specified range (inclusive)

3. 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.

Sort By: SORT BY: A clause used to arrange the result set of a query in a specified order

1. Use Dropdown: Selectable “fields” that exist in the selected SharpenDB table.

2. Use Variable: A user-defined variable containing a string that matches a pre-exist field in the SharpenDB table.

DISTINCT: A keyword that filters the result set to return only unique values, eliminating duplicate entries from the query results.

1. Use Toggle

   1. Disabled: set by default

   2. Enabled

LIMIT: A clause in queries that restricts the number of records returned from a query, allowing users to control the size of the result set.

1. Use Number: Selectable numerical value.

2. Use Variable: A user-defined variable containing a numerical value.

Offset: A parameter used in database queries to specify the starting point for returning a subset of results, effectively skipping a defined number of records before beginning to retrieve data.

1. Use Number: Selectable numerical value.

2. Use Variable: A user-defined variable containing a numerical value.

Unpaginated Count: Provides the total number of records matching a query, ignoring any pagination limits or offsets.

1. Use Toggle

   1. Disabled: set by default

   2. Enabled

Variables: A named storage location in programming that holds a value for the data returned in the query.

1. Name: The variable name should be clear and concise to enhance understanding of its purpose, the variable can be referenced throughout the flow.

2. Jsonpath: A syntax for querying and extracting specific data from JSON structures, similar to XPath for XML, allowing precise access to nested elements and values.

   1. For example, the Jsonpath $.results.0.fieldNameHere, If your field name was areaCode, the Jsonpath would appear as $.results.0.areaCode

   2. If the Jsonpath used was areaCode, you could name the variable as areaCodeReturned.

      1. The variable could be retrieved later in the flow by referencing the variable as $(areaCodeReturned)

Timeout: Configurable amount of time, in seconds, to wait for the SharpenDB query to respond with a result set.

1. Use Dropdown: Specify a numerical value for when the time-out is met.

2. 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.

1. Default: The Default path is taken upon panel execution.

2. Timeout: The request time out was met, likely due to a non-performant query.