Function getUnreadFeedbackCount

packages/core/src/feedback/feedback-service.ts:533–539

()

 * Used to drive the red-dot badge on Profile / Settings menus.
 */
export async function getUnreadFeedbackCount(): Promise<number> {
  const db = await getDB();
  const rows = await db.select<{ count: number }>(
    "SELECT COUNT(*) as count FROM feedback WHERE has_new_reply = 1",
  );
  return rows[0]?.count ?? 0;
}

/**
 * Refresh feedback status from the worker for all locally-known issues, then