Skip to Content
This question has been flagged
qwebreportingreport
3 Respostes
8811 Vistes
Avatar
Seppe De Roeck

Hi all,

In a QWeb report I am trying to retrieve a product template that is the template referenced from a certain selected variant.

As product_tmpl_id is the field on a product variant level referring to the template, I want to fetch the selected variant and then get the linked template.


<!-- GET TEMPLATE DATA BASED ON FIRST SELECTED VARIANT -->

<t t-set="prod_obj" t-value="request.registry['product.template']"/>

<t t-set="var_obj" t-value="request.registry['product.product']"/>

<t t-set="prodvar" t-value="var_obj.browse(request.cr, uid, [('id','=',doc_ids[0])])" />


The prodvar variable is properly set and retrieved.  It returns product.product(('id', '=', 19),) when I select the variant with ID=19

The following line however gives an error :

<t t-set="prodtemp" t-value="prod_obj.browse(request.cr, uid, [('id','=',prodvar.product_tmpl_id)])" />

Also this alternative gives an error :

<t t-set="prodtemp" t-value="prod_obj.browse(request.cr, uid, [('id','=',prodvar.product_tmpl_id.id)])" />


Thanks so much for any tips.  I guess it must be fairly simple to solve but don't seem to find it myself :-)

Seppe

Avatar
Descartar
Avatar
Jusab Sida (jsi)
Best Answer

Hi,

You can try this one.

<t t-set="prod_obj" t-value="request.registry['product.template']"/>
<t t-set="var_obj" t-value="request.registry['product.product']"/> 
<t t-set="prodvar" t-value="var_obj.browse(request.cr, request.uid, doc_ids[0])" />

and if you need to search records then search like,

<t t-set="prodtemp" t-value="prod_obj.search(request.cr, request.uid, [('id','=',prodvar.product_tmpl_id.id)])" />

The problem is you are passing Domain in browse method.

Hope this one help you.

Avatar
Descartar
Avatar
Ankit H Gandhi(AHG)
Best Answer

Hello All,

Thank you @ Jusab, +1.

For odoo version 11, You can use below code.

<t t-set="prod_obj" t-value="request.env['product.template']"/>

<t t-set="prodtemp" t-value="prod_obj.search([])" />

<t t-foreach="prodtemp" t-as="prod">

<t t-esc="prod.name"/>

</t>

Hope above code will be helpfully.

Best Thanks,

Ankit H Gandhi.

Avatar
Descartar
Avatar
Seppe De Roeck
Autor Best Answer

Thanks Jusab,


All clear now and working :-)

tx

Seppe

Avatar
Descartar
Related Posts Respostes Vistes Activitat
Qweb - Drop trailing 0's after decimal Solved
qweb reporting report
Avatar
Avatar
Avatar
Avatar
8
de des. 23
23270
How to generate custom report with custom data from a wizard? v16 Solved
qweb reporting report odoo16features
Avatar
Avatar
1
de maig 24
4512
How to add the order number in the footer (QWEB)
qweb reporting report odoo10
Avatar
0
de jul. 17
4386
odoo 16 report target new page scss
qweb report
Avatar
Avatar
1
d’abr. 25
2182
Missing external identifier on new external layout template Solved
qweb report
Avatar
Avatar
2
de març 25
2775