Function getManageableWorkspaces

apps/sim/lib/workspaces/permissions/utils.ts:448–504

(userId: string)

 * }>> - A list of workspaces that the user has access to
 */
export async function getManageableWorkspaces(userId: string): Promise<
  Array<{
    id: string
    name: string
    ownerId: string
    accessType: 'direct' | 'owner'
  }>
> {
  const ownedWorkspaces = await db
    .select({
      id: workspace.id,
      name: workspace.name,
      ownerId: workspace.ownerId,
    })
    .from(workspace)
    .where(and(eq(workspace.ownerId, userId), isNull(workspace.archivedAt)))

  const adminWorkspaces = await db
    .select({
      id: workspace.id,
      name: workspace.name,
      ownerId: workspace.ownerId,
    })
    .from(workspace)
    .innerJoin(permissions, eq(permissions.entityId, workspace.id))
    .where(
      and(
        isNull(workspace.archivedAt),
        eq(permissions.userId, userId),
        eq(permissions.entityType, 'workspace'),
        eq(permissions.permissionType, 'admin')
      )
    )

  const orgAdminWorkspaces = (await getOrgAdminWorkspaceRows(userId, 'active')).map((ws) => ({
    id: ws.id,
    name: ws.name,
    ownerId: ws.ownerId,
  }))

  const ownedSet = new Set(ownedWorkspaces.map((w) => w.id))
  const seen = new Set(ownedSet)
  const combined: Array<{
    id: string
    name: string
    ownerId: string
    accessType: 'direct' | 'owner'
  }> = ownedWorkspaces.map((ws) => ({ ...ws, accessType: 'owner' as const }))

  for (const ws of [...adminWorkspaces, ...orgAdminWorkspaces]) {
    if (seen.has(ws.id)) continue
    seen.add(ws.id)
    combined.push({ ...ws, accessType: 'direct' as const })
  }

  return combined
}