Method getTasksBySkill

packages/memos-core/src/storage/sqlite.ts:1998–2009

(skillId: string)

  }

  getTasksBySkill(skillId: string): Array<{ task: Task; relation: TaskSkillRelation }> {
    const rows = this.db.prepare(`
      SELECT t.*, ts.relation
      FROM task_skills ts JOIN tasks t ON t.id = ts.task_id
      WHERE ts.skill_id = ?
      ORDER BY t.started_at DESC
    `).all(skillId) as Array<TaskRow & { relation: string }>;
    return rows.map(r => ({
      task: rowToTask(r),
      relation: r.relation as TaskSkillRelation,
    }));
  }

  countSkills(status?: string): number {
    const cond = status ? "WHERE status = ?" : "";