Kexi 3.2.0-3 (Debian 12) – Full text search in queries does not work

Help
1

Queries do only work, if in criteria the ‘exact text’ of a field is inserted.

Using the asterisk (*) or boolean operators (NOT, OR, or AND) either produce no results or even cause Kexi to crash, although the SQL editor confirms the query as correct.
(compare: Getting started with SQLite Full-text Search By Examples)

Unfortunately there is no documentation on how to do queries in Kexi.

2

The user interface of Kexi hides Sqlite, but to operate Kexi you need Sqlite knowledge. That makes it difficult for beginners to explore Kexi.

Flexible text search in Kexi is possible with the operators LIKE, AND and OR.

  • use the percent sign % wildcard instead of a asterisk (*)
  • use AND OR operators to combine multiple conditions
    (see: sqlitetutorial_net)

To activate FTS (full text search) a virtual table has to be created in a sqlite shell, which is not included in Kexi. So FTS is not possible.