(SQL) Filter Database Node

(

Data/Database/Search

Filter Database

filter_local_dbdata

Inputs6

Outputs2

Security exposureUnrated

Packagedata

Ratings

Scores range from 0 to 10. Higher values mean more impact, exposure, or operational weight.

No score metadata has been set for this node yet.

Input Pins

6

Input

Execution

exec_in

Database

Struct

database

Database Connection Reference

SchemaNodeDBConnectionNodeDBConnectionNodeDBConnection1 fields

cache_keystringrequired

Schema enforced

SQL Filter

String

filter

Optional SQL filter on the table's columns. Use $name for a value that comes from a wire — `id = $id` mints a `$id` pin, and the value is bound as a literal instead of being pasted into the predicate.

Params

Struct

params

Values for the filter's $placeholders, as an object keyed by placeholder name without the $ (e.g. {"customer_id": 42}). Only needed when the filter itself comes from a wire — a literal filter derives one pin per placeholder instead. Where both supply the same name, the derived pin wins unless it is empty.

Schemaobjectobjectobject0 fields

No named fields in this schema.

Default {}

Limit

Integer

limit

Limit

Default 10

Offset

Integer

offset

Offset

Default 0

Output Pins

2

Created Database

Execution

exec_out

Done Creating Database

Values

Struct Array

values

Found Items

Schemaobjectobjectobject0 fields

No named fields in this schema.

Node Info

Internal name

filter_local_db

Category

Data/Database/Search

Version

2