Full-Text Search Node

F

Data/Database/Search

Searches the Database using Full-Text Search

fts_search_local_dbdata

Inputs8

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

8

Input

Execution

exec_in

Database

Struct

database

Database Connection Reference

SchemaNodeDBConnectionNodeDBConnectionNodeDBConnection1 fields

cache_keystringrequired

Schema enforced

Search Term

String

search

Full Text Search Term

Fields

String Array

fields

Column names to search with FTS (searches all indexed columns if empty)

Default []

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

Done

Execution

exec_out

Done Searching Database

Values

Struct Array

values

Found Items

Schemaobjectobjectobject0 fields

No named fields in this schema.

Node Info

Internal name

fts_search_local_db

Category

Data/Database/Search

Version

2