get roots using unbound option in where and preloading deprecate attribute