Count relationship quantity via pivot
models:
ProductPack
Product
ProductPackPivot (n n table):
pivot extra field -> product_quantity
for each ProductPack i want to know how many products it has. at the moment im doing it like this, but this only counts the relationships:
and i need to go to the pivot, and get the
im kinda lost on how to achieve it.
example:
lets say i have a product pack that has 2 products:
4 waters
2 forks
the product pack has 2 products, but really has 4+2 products, so i need to get 6 instead of 2
ProductPack
Product
ProductPackPivot (n n table):
pivot extra field -> product_quantity
for each ProductPack i want to know how many products it has. at the moment im doing it like this, but this only counts the relationships:
and i need to go to the pivot, and get the
product_quantity field instead of counting the relationim kinda lost on how to achieve it.
example:
lets say i have a product pack that has 2 products:
4 waters
2 forks
the product pack has 2 products, but really has 4+2 products, so i need to get 6 instead of 2
