Data Query
Used to execute a database query using SQL.
Inputs
| 1. | Query Text | (Mandatory) | The SQL query that will be executed against the database |
| 2. | Generates Resultset | (Mandatory) | Select Yes to retrieve the results of the query. Generally, select
|
| 3. | Row Limit | (Optional) | The maximum number of rows to return if a Resultset is required. Default value is 25 |
| 4. | Time Out | (Optional) | The number of seconds to allow for the query before failing this step for taking too long. Default value is 5 seconds |
| 5. | Lookup Timeout | (Optional) | The number of seconds to run the query for before timing out. Defaults to 5 seconds |
Fig. 1 - Data Query - Inputs
Outputs
| 1. | Result Set | The results of the query if Input Generates Resultset is set to Yes. The data will contain at most the number of rows specified in the Row Limit Input |
| 2. | Result Rows | If Input Generates Resultset is set to Yes, this contains the number of rows in the result set. Otherwise it contains the number of rows affected |
| 3. | Error status | Use for diagnostic purposes only. If executing the query generated an error, this Output contains the error reported by the database interface |
Fig. 2 - Data Query - Outputs
Outcomes
| 1. | Next | The query was successful |
| 2. | Fail | An error was returned from Softdial CallGem™ |
Fig. 3 - Data Query - Outcomes