Function buildInlineCohortJoin

packages/db/src/services/chart.service.ts:156–164

(
  cohortId: string,
  projectId: string,
  tableAlias: string,
)

}

export function buildInlineCohortJoin(
  cohortId: string,
  projectId: string,
  tableAlias: string,
): string {
  const cohortAlias = getCohortAlias(cohortId);
  const cohortQuery = buildCohortMembershipQuery(cohortId, projectId);
  return `LEFT ANY JOIN (${cohortQuery}) AS ${cohortAlias} ON ${cohortAlias}.profile_id = ${tableAlias}.profile_id`;
}

export function extractCohortId(breakdownName: string): string | null {
  if (breakdownName.startsWith('cohort:')) {