Full-Text Search

Tables declare what is searchable. Two field-level properties control how a field participates in search: indexed makes it queryable, and fullTextSearch (on rich-text) enables FTS indexing for formatted content. Components then pick the engine that consumes these — see search-overview.

Field properties

These extend the base field properties shared by every field type.

Declaring searchable fields

Mark every field you want the fts, trigram, or hybrid engines to reach with indexed: true. A rich-text field additionally needs fullTextSearch: true, because its stored value is HTML markup rather than plain text.

tables:
  - name: articles
    fields:
      - { id: 1, name: title, type: single-line-text, indexed: true }
      - { id: 2, name: summary, type: long-text, indexed: true }
      - { id: 3, name: tags, type: single-line-text, indexed: true }
      - { id: 4, name: body, type: rich-text, indexed: true, fullTextSearch: true }

fullTextSearch on rich text

The rich-text field stores formatted HTML. Setting fullTextSearch: true enables full-text-search indexing of its text content so the field can participate in fts/hybrid queries alongside plain-text fields.

- id: 5
  name: article_content
  type: rich-text
  required: true
  maxLength: 10000
  fullTextSearch: true
  toolbar: [bold, italic, link, heading, list]

Plain long-text and single-line-text fields do not need fullTextSearch — set indexed: true and they are FTS-ready. The fullTextSearch flag exists specifically for rich-text because its stored value is HTML markup rather than plain text. See text-fields for the full rich-text property set.

PostgreSQL vs SQLite

Trigram fuzzy matching

The pg_trgm extension breaks text into three-character sequences (trigrams) and matches on overlap, tolerating typos and partial words. This powers the trigram and hybrid engines. A field used for fuzzy search should be indexed: true so PostgreSQL can build a trigram (GIN/GiST) index.

tables:
  - name: products
    fields:
      - { id: 1, name: name, type: single-line-text, indexed: true }

# Component side — fuzzy matching on the indexed field
- type: data-table
  dataSource:
    table: products
    mode: search
    searchFields: [name]
    searchEngine: trigram

A query of prodct still matches product; lapto matches laptop. Pair trigram with FTS using searchEngine: 'hybrid' to keep relevance ranking for exact terms while retaining typo tolerance for the rest.

Related

• Search Overview — the four search engines and the search data-source mode.
• Search Components — searchInput, list, pageSearch, and toolbar search.
• Text Fields — rich-text, long-text, and the fullTextSearch flag.
• Tables Overview — indexed and other base field properties.