i need to access the default code in the table product_product (i need to use this field since the product is a variant)but i dont know how to do it
i already tried
l.product_id.product_product_tmpl_id.default_code
but it gives an empty result while their is value in the actual table
You should try the following code:
<span t-field="l.product_id.default_code"/>
If product has default code, it will display.
the thing is the product is a variant so their is no default code for the product in the table product_template while the value exist for the variant in the product_product table and thats the value i want to get and show in my report
product.product (variant) inherits product.template and because of that you can access all the fields of product.template in product.product
i know ,but like i said i cant access the default_code value in product_product and thats what im asking on how to do it
Are you facing any error?
no, just showing an emty result but i checked the table and the value is their
the answer is l.product_id.code even if the fields name in the db is default_code
Opret en konto i dag for at få glæde af eksklusive funktioner, og bliv en del af vores skønne fællesskab!
Tilmeld dig| Relaterede indlæg | Besvarelser | Visninger | Aktivitet | |
|---|---|---|---|---|
|
2
apr. 23
|
11523 | ||
|
3
sep. 20
|
6873 | ||
|
2
apr. 20
|
8804 | ||
|
2
sep. 19
|
7513 | ||
|
2
feb. 18
|
9508 |
1. Use the live chat to ask your questions.
2. The operator answers within a few minutes.
sorry its l.product_id.product_tmpl_id.default_code
still when i show a date or id or any other value from the same table it woks except for default_code