Description
Query rows from a FlowForge-managed database with filters, sort, limit.
DB: Query
db_query · action · Database · Available · v1.0.0
⚙️ Configuration parameters
Fields shown in the editor when configuring the node. Generated directly from the NodeDefconfigFields.
| Field | Type | Required | Default | Description |
|---|---|---|---|---|
databaseIdDatabase | db-picker | yes | — | — |
tableTabella | db-table-picker | yes | — | — |
filtersJsonFiltri (WHERE) | filter-rows | no | — | Tutti i filtri sono combinati in AND. Lascia vuoto per nessun WHERE. |
selectJsonColonne da selezionare | chip-list | no | — | Vuoto = SELECT *. Aggiungi i nomi delle colonne. |
orderByJsonOrdina per (ORDER BY) | sort-rows | no | — | Aggiungi una o più colonne. La prima è l'ordinamento primario. |
limitLimit | number | no | 100 | — |
offsetOffset | number | no | — | — |
💡 Configuration example
JSON snippet of the node as it appears in the workflow. Values are derived fromdefaultValue and from required parameters.
{
"id": "node-db_query-1",
"defId": "db_query",
"label": "DB: Query",
"config": {
"databaseId": "<databaseId>",
"table": "<table>",
"limit": 100
}
}🔗 Related nodes in the same category
Ready to use DB: Query?
Available now on all FlowForge plans. Try it free without a credit card.
Start freeBrowse all nodes