Hey community! Hope you are all doing good.
I have this kind of schema for my order table
Fisrt I wanted to filter orders by a specific variation_id and did successfuly, thanks to joins
Now I also want to filter orders by a specific store_id, but can't flatten stores array to access store_id
Any idea how I can acheive this? Thanks