Eager loading with limit and order by edge field

[ltns35]

Hi,

I'm using the following code to eager loading a product with all its relationships, but I'm not receiving the correct values.

What I want to achieve is the following: retrieve a product with 5 stores that have the lowest final price.

entity, err := p.client.Product.Query().
	Where(product.IDEQ(id)).
	WithCategory().
	WithStorePricing(func(query *ent.StoreProductPricingQuery) {
		query.WithStore().
			WithPricing(func(q *ent.ProductPricingQuery) {
				q.Order(ent.Asc(productpricing.FieldPriceFinal))
			}).
			Limit(5)
	}).
	Only(ctx)