Method taskFtsSearch

packages/memos-core/src/storage/sqlite.ts:1914–1941

(query: string, limit: number, owner?: string)

  }

  taskFtsSearch(query: string, limit: number, owner?: string): Array<{ taskId: string; score: number }> {
    const sanitized = sanitizeFtsQuery(query);
    if (!sanitized) return [];
    try {
      let sql = `
        SELECT t.id as task_id, rank
        FROM tasks_fts f
        JOIN tasks t ON t.rowid = f.rowid
        WHERE tasks_fts MATCH ?`;
      const params: any[] = [sanitized];
      if (owner) {
        sql += ` AND (t.owner = ? OR t.owner = 'public')`;
        params.push(owner);
      }
      sql += ` ORDER BY rank LIMIT ?`;
      params.push(limit);
      const rows = this.db.prepare(sql).all(...params) as Array<{ task_id: string; rank: number }>;
      if (rows.length === 0) return [];
      const maxAbsRank = Math.max(...rows.map((r) => Math.abs(r.rank)));
      return rows.map((r) => ({
        taskId: r.task_id,
        score: maxAbsRank > 0 ? Math.abs(r.rank) / maxAbsRank : 0,
      }));
    } catch {
      this.log.warn(`Task FTS query failed for: "${sanitized}", returning empty`);
      return [];
    }
  }

  listPublicSkills(): Skill[] {
    const rows = this.db.prepare("SELECT * FROM skills WHERE visibility = 'public' AND status = 'active' ORDER BY updated_at DESC").all() as SkillRow[];