Repo Select

export const findNotAdultOrTooAdultUsersFromCompaniesThatHaveAssetsThatHasSensorsWithPointsThatOlderThan =
  (dateTime) =>
    UserRepo.select((user) => user.belongsToCompany())
      .where((user) =>
        user
          .age((age) => age.or(age.lessThan(18), age.greaterThan(100)))
          .belongsToCompany((company) =>
            company.hasAsset((asset) =>
              asset.hasSensor((sensor) =>
                sensor.hasPoint((point) =>
                  point.createdAt((createdAt) =>
                    createdAt.greaterThan(dateTime)
                  )
                )
              )
            )
          )
      )
      .order((user) =>
        user.age("DESC").belongsToCompany((company) => company.name("ASC"))
      )
      .take(10, 10)
      .execute();