Function getResearchArticleCount

server/src/routes/latest.ts:30–40

* Get the count of published research perspectives from the Editorial working group.

()

 * Get the count of published research perspectives from the Editorial working group.
 */
async function getResearchArticleCount(): Promise<number> {
  const result = await query<{ count: string }>(
    `SELECT COUNT(*) as count
     FROM perspectives p
     JOIN working_groups wg ON p.working_group_id = wg.id
     WHERE p.status = 'published'
       AND wg.slug = 'editorial'
       AND (p.source_type IS NULL OR p.source_type NOT IN ('rss', 'email'))`
  );
  return parseInt(result.rows[0]?.count || "0", 10);
}

// Article type for API responses
interface LatestArticle {