Function getSingleUserOrganization

apps/web/src/lib/organizations/organizations.ts:141–150

(userId: User['id'])

    })
    .from(organization_memberships)
    .innerJoin(organizations, eq(organizations.id, organization_memberships.organization_id))
    .where(
      and(eq(organization_memberships.kilo_user_id, userId), isNull(organizations.deleted_at))
    );
  return rows;
}

export async function userHasOrganizations(userId: User['id']): Promise<boolean> {
  const result = await db
    .select({ id: organization_memberships.id })
    .from(organization_memberships)
    .innerJoin(organizations, eq(organizations.id, organization_memberships.organization_id))
    .where(and(eq(organization_memberships.kilo_user_id, userId), isNull(organizations.deleted_at)))