Full-Text Search Node

F

Data/Database/Search

Full-Text Search

Searches the Database using Full-Text Search

fts_search_local_dbdata

Inputs7

Outputs2

Security exposure10/10

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

7

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

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

Node Info

Internal name

fts_search_local_db

Category

Data/Database/Search