mirror of
https://github.com/multica-ai/multica.git
synced 2026-06-17 03:38:32 +02:00
23136da34f
* feat(search): implement full-text search for issues Add pg_bigm-based full-text search across issue titles and descriptions, with API endpoint, CLI subcommand, and web Cmd+K search dialog. - Migration 032: pg_bigm extension + GIN indexes on title/description - Server: GET /api/issues/search?q=... with pagination and total count - CLI: `multica issue search <query>` with table/json output - Web: Cmd+K command palette using cmdk, with debounced search Co-Authored-By: Claude Opus 4.6 (1M context) <noreply@anthropic.com> * fix(search): address review feedback on search implementation 1. Escape LIKE special characters (%, _, \) in handler to prevent matching anomalies from user input. 2. Wire AbortController signal into searchIssues fetch so in-flight requests are actually cancelled on new input. 3. Fix offset=0 falsy check — use !== undefined instead of truthiness. 4. Merge results + count into single query using COUNT(*) OVER() window function, eliminating the duplicate DB round-trip. 5. Exclude done/cancelled issues by default; add include_closed parameter to API, CLI (--include-closed), and web client. Co-Authored-By: Claude Opus 4.6 (1M context) <noreply@anthropic.com> * fix(search): default web search to include all statuses Pass include_closed: true in the web Cmd+K search so results include done and cancelled issues by default, matching the reviewer's request. Co-Authored-By: Claude Opus 4.6 (1M context) <noreply@anthropic.com> * feat(search): add comment search with snippet extraction Extend search to cover issue comments in addition to title/description. Results are deduplicated at the issue level, with match_source and matched_snippet fields indicating where and what matched. - Migration 033: pg_bigm GIN index on comment.content - SQL: EXISTS subquery for comment matching, correlated subquery for snippet extraction, 3-tier ranking (title > description > comment) - Server: SearchIssueResponse with match_source and matched_snippet - Web: show comment icon + snippet below issue title when matched - CLI: MATCH column shows source and truncated snippet Co-Authored-By: Claude Opus 4.6 (1M context) <noreply@anthropic.com> * feat(search): redesign search dialog to match Linear's spacious style - Widen dialog from sm (384px) to xl (576px) with top-20% positioning - Larger search input with icon, generous padding, and ESC hint - Use cmdk primitives directly for full style control - Taller result list (400px / 50vh), spacious result items (py-2.5) - Rounded-lg items with accent highlight on selection - Cleaner border separator between input and results --------- Co-authored-by: Claude Opus 4.6 (1M context) <noreply@anthropic.com>
4 lines
126 B
SQL
4 lines
126 B
SQL
DROP INDEX IF EXISTS idx_issue_description_bigm;
|
|
DROP INDEX IF EXISTS idx_issue_title_bigm;
|
|
DROP EXTENSION IF EXISTS pg_bigm;
|