Function resolveAgentOwnerUserIds

server/src/notifications/compliance.ts:37–53

* Find user IDs for the organization that owns an agent URL. * Looks up member_profiles where the agents JSONB contains the URL, * then finds org members to notify.

(agentUrl: string)

 * then finds org members to notify.
 */
async function resolveAgentOwnerUserIds(agentUrl: string): Promise<string[]> {
  try {
    const result = await query(
      `SELECT om.workos_user_id
       FROM member_profiles mp
       JOIN organization_memberships om
         ON om.workos_organization_id = mp.workos_organization_id
       WHERE mp.agents @> $1::jsonb
       LIMIT 5`,
      [JSON.stringify([{ url: agentUrl }])],
    );
    return result.rows.map((r: any) => r.workos_user_id);
  } catch (error) {
    logger.debug({ error, agentUrl }, 'Could not resolve agent owner');
    return [];
  }
}

/**
 * Extract a short agent name from the URL for display.