Full Text Search
Overview
The Full Text Search node searches across database tables and columns using LIKE queries or MySQL MATCH AGAINST full-text indexing. It returns ranked results with optional search term highlighting.
Category
Data — data/fullTextSearch
Settings
| Setting | Type | Default | Description |
|---|---|---|---|
| sourceMode | String | vantage | vantage or external database connection |
| tables | Array | [] | Table names to search across |
| searchColumns | Array | [] | Column names to search within (e.g., title, body, description) |
| queryField | String | query | Upstream field containing the search query string |
| highlightResults | Boolean | true | Wrap matching terms in highlight markers |
| limit | Number | 20 | Maximum results to return |
| offset | Number | 0 | Pagination offset |
Inputs & Outputs
- input1 — Upstream data containing the search query
- output1 — Search results with metadata (total count, searched tables)
Use Cases
- Knowledge base search — Search across article titles and bodies for user queries
- Product catalog — Full-text search across product names, descriptions, and tags
- Support ticket lookup — Search ticket titles and descriptions for related issues