Function getChannelByWebsiteSlug

server/src/db/notification-channels-db.ts:220–227

(slug: string)

 * Get a channel by its website slug
 */
export async function getChannelByWebsiteSlug(slug: string): Promise<NotificationChannel | null> {
  const result = await query<NotificationChannel>(
    `SELECT * FROM notification_channels
     WHERE website_slug = $1 AND website_enabled = true AND is_active = true`,
    [slug]
  );
  return result.rows[0] || null;
}

/**
 * Check if a channel is website-only (no Slack delivery)