I have a custom field I added in the product.category table named "flag". Each of my product categories have a flag. In some product search fields, I wish to restrain the product categories to this given flag.
I know how to restrict the product category by using the category name:
Code:
<field name="product_id" select="1" domain="[('categ_id','=','NameABC')]"/>
But how can I extend this domain syntax to have access to the flag field I created in the product.category table? I'm looking for something like:
Code:
<field name="product_id" select="1" domain="[('categ_id.flag','=','FlagName')]"/>
But this doesn't work. Anybody can help me? Thanks.