Skip to content

Developers · Data

Keyword Match Type

Last updated 2 November 2026

Search, by default, tries to match the keyword exactly with the words in the field. For example, when you search for 'alan', it will not only match the value 'alan' but also 'Mike Alan' and 'Mike Alan and Tommy'. You can also define a keyword to match words that start or end with the given phrase.

Match type

For example, you want to find records in a table with a word that starts with :

query search_people {
  records(
    per_page: 20
    filter: {
      table: { value: "person" }
      fulltext: { keyword: "Al", match_type: STARTS_WITH }
    }
  ) {
    results {
      name: property(name: "name")
    }
  }
}

Returns records with a word starting with , e.g. , , .

The filter takes an optional parameter. When you do not set it, EXACT is used. Available match types are outlined in the following table:

Match type Description
The keyword 'alpha' matches 'alpha' OR 'alpha gamma' OR any sentence containing the exact 'alpha' word; this is the default behavior.
The keyword 'alp' is the shortcut for 'alp*' and matches 'alpha', 'alphabet', and any sentence containing any word starting with 'alp'.
The keyword 'alp' is the shortcut for 'alp' and matches 'alpha alphabet somealpha'.
The keyword 'alp' means '*alp' and matches 'scalp'.
The keyword matches words that are close to it, so a small typo is allowed. For example, 'Keywodr' matches 'Keyword'.

Wildcards

Keyword also accepts wildcards  for a single character and for more. For example:

  • will match , , but not
  • will match , , but not