[New] mobieusKnow: Knowledge search ignores article body — only titles are searchable

Area: mobieusKnow (audit p6) · Surface: /know/search, GET /api/know/search, GET /api/v1/know/search · Dimension: competitor-gap · Severity: major

Every helpdesk and KB competitor — Zendesk, Intercom, Help Scout, Notion, Confluence — does full article-body search as table stakes, with snippet highlighting of the matched passage. mobieusKnow only indexes the title, so the search box silently fails for the most common query pattern (searching for content). This makes a community-built knowledge base feel broken: the more an article covers, the less findable it is, because findability depends entirely on whether the searcher guessed words in the title. It also undercuts the mobieusHelp deflection use-case the searchJson endpoint was built for (KnowledgeController.php:504-518) — deflection needs body matches.

Evidence

KnowledgePage::search() (platform/src/Models/KnowledgePage.php:82-107) only ever matches the title: the FULLTEXT branch is `MATCH(kp.title) AGAINST(:q IN BOOLEAN MODE)` and the LIKE fallback is `kp.title LIKE :q`. The schema confirms the only FULLTEXT index is `FULLTEXT KEY ft_title (title)` on knowledge_pages (schema.sql:3439); knowledge_revisions.content_markdown has NO fulltext index (schema.sql:3450-3468). The V1 API search is even narrower: `(kp.title LIKE :q OR kp.slug LIKE :q OR t.name LIKE :q)` (KnowledgeApiController.php:251) — also never touches the body. A member searching for a phrase that appears in the body of an article but not its title gets zero results.

Suggested fix. Add a FULLTEXT index on knowledge_revisions.content_markdown (or a denormalized current-body column on knowledge_pages) and join the current approved revision into the search query so MATCH covers title + body. Return a highlighted snippet of the matched passage in results (search.php currently shows only title + author + date). Keep the boolean-mode title boost so title hits still rank first.

Filed by the automated tenant-app audit and adversarially evidence-verified. Status: verified. Open — not yet actioned.