How to show Count relationship in table?
What im trying to do:
i want to make a report for mutation that happen in the products based on monthly filter.
the model is product has many transaction and transaction has one transaction details.
the stock in and out is in the transaction details.
what i did:
because its based on monthly filter so i think i would choose the transactions.
this is my base query.
my issue is:
how to show the product name, and then total stock in from the transaction details and total stock out. i wont to see all the transaction just the product name and the total of mutation.
i want to make a report for mutation that happen in the products based on monthly filter.
the model is product has many transaction and transaction has one transaction details.
the stock in and out is in the transaction details.
what i did:
because its based on monthly filter so i think i would choose the transactions.
this is my base query.
my issue is:
how to show the product name, and then total stock in from the transaction details and total stock out. i wont to see all the transaction just the product name and the total of mutation.
