Full-text search via FTS5 (cross-branch capable)
bc_search_ftsSearch indexed Business Central AL source code using FTS5 full-text queries. Supports phrases, boolean operators, and prefix matching. Returns ranked snippets with highlighted matched tokens.
Instructions
Token-based full-text search across indexed AL sources using SQLite FTS5. Faster than bc_search_code (no disk re-scan) and supports cross-branch queries. Use FTS5 syntax: bare terms ("Customer Posting"), phrases (""Sales Header""), boolean (term1 AND term2), prefixes (Cust*). Returns ranked snippets with matched tokens wrapped in <<...>>. For regex patterns, prefer bc_search_code.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| query | Yes | FTS5 query, e.g. "OnAfterPost", "\"Sales Header\" AND Customer", "Approv*". | |
| branches | No | Optional list of branches to search (must already be indexed). If omitted, all indexed branches. | |
| app | No | Restrict to a single top-level app (exact match), e.g. "Base Application". | |
| object_type | No | Restrict to a specific AL object type. | |
| limit | No | Max matches to return. Default 50. | |
| offset | No | Pagination offset. Default 0. |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
| query | Yes | ||
| total | Yes | ||
| offset | Yes | ||
| limit | Yes | ||
| items | Yes |