SharpenDB SELECTDataSharpensharpenDbSelect· Version 1.0.0
Run a SELECT query on a table in SharpenDB.
Reads rows from a SharpenDB table. Choose the table and the fields to return (leave fields blank for all), narrow results with Where conditions, and optionally sort. Capture columns from the result into variables by JSONPath so later nodes can use them with $(name). The flow takes default when the query succeeds. A query SharpenDB does not answer within 20 seconds takes timeout, or fallback when timeout is not wired. The node's Timeout field is not applied: it does not change that 20-second limit.
Integration required
Connect the Sharpen integration before using this node.
Fields
| Field | Type | Required | Description |
|---|---|---|---|
Tabletable | dynamicDropdown | Required | The table to query from. |
Fieldsfields | dynamicDropdown | Optional | The fields from the table to include in the query. Leave blank to query all. |
Wherewhere | dynamic array of fields with options | Required | WHERE conditions to filter query results. Each condition compares a table field using an operator against a value. |
Where OperatorwhereConditionOperator | string | Optional | What operator (AND/OR) to use for the where condition. |
Sort BysortBy | dynamicDropdown | Optional | Which field to sort the query by. Leave blank for default sorting. |
Distinctdistinct | boolean | Optional | When true, removes duplicate rows from the query results. |
Limitlimit | number | Optional | Maximum number of rows to return (1-25). |
Offsetoffset | number | Optional | Number of rows to skip before returning results. Use with limit for pagination. |
Unpaginated Countcount | boolean | Optional | When true, includes the total count of matching rows before pagination is applied. |
Variablesvariables | array of objects | Optional | Save variables from the data returned. |
Timeouttimeout | number | Optional | Not applied yet: SharpenDB queries always wait up to 20 seconds, whatever this is set to. |
Exits
defaulttimeout
System exits (auto-injected, hidden when unwired): invalidInput, fallback.