I have built my products catalog with the products TV + collections option.
I wonder how to filter the result by stock value.
To be clear : I want to exclude all product out of stock within my pdoResources request :
[[!pdoResources? &parents=`[[*id]]` &includeTVs=`name,description` &tpl=`products__item` &tvPrefix=`tv.` &processTVs=`1` &includeContent=`1` &sortby=`pagetitle` &sortdir=`ASC` &limit=`1000` &showLog=`0` ]]
There is the &where parameter but how to use the stock value stored in Commerce ?
On the Commerce doc, there is the &where parameter with commerce.get_products snippet but is it possible to use it with pdoResources ?