I’ve an oddly particular problem, displaying the full rely of merchandise in orders of a particular order standing. So as an instance there’s 52 orders with the order standing “Processing”, I am attempting to retrieve a complete rely of line gadgets in these orders to then show on the entrance finish.
Instance: “Prospects like you’re enjoying with 6,829 Fidget Spinners proper now!”
The place the quantity would primarily be a complete rely of line gadgets in orders with the “Accomplished” order standing.
I believe I perceive obtain this from a logical standpoint — run a question to filter the database for orders of a particular order standing, then retrieve the full line gadgets in every order, and add these all collectively, however I am struggling to know how that interprets in code, I am a entrance finish dev.
Any pointers could be drastically appreciated, thanks kindly.