Query Enricher
Description
The Query enricher allows to bring to the scenario data returned by an SQL SELECT statement issued against the target data provider. The Query is autogenerated based on the integration with a database system like Postgres or MySQL; its name will be Integration-name Query. Go to the Admin Panel, Integrations tab to configure integration with your database. Consult Step by Step instructions for details on how to configure your integration. .
Parameters and configuration
| Name | Description |
|---|---|
| Result strategy | If a query returns more than just one record and you need just one, you can set result strategy option to single result - this will ensure that only one db record will be used to populate the variable which holds output from this node. |
| Query | The SQL SELECT statement. If parameter(s) need to be passed to the SQL query, use "?" as a placeholder for a parameter value; Nussknacker will dynamically adjust the node configuration window to include the entry field for the parameter(s). |
| Cache TTL | How long the lookup result can be cached. Lookups which use cached values are faster |
| arg1, .., argN | Arguments to be supplied to the SELECT statement. |
| Output variable name | This variable will contain the result of the query |