Siirry sisältöön
Sinun on rekisteröidyttävä, jotta voit olla vuorovaikutuksessa yhteisön kanssa.
Kaikki kirjoitukset Ihmiset Merkit
Tunnisteet (Näytä kaikki)
odoo accounting v14 pos v15
Tietoa tästä foorumista
Tämä kysymys on merkitty
domainone2manyodoo11
4 Vastaukset
8802 Näkymät
Avatar
Rodrigo Robles

Hello, I'm using Google Spreadsheet integration to export reports to Google Drive from Odoo 11 Enterprise.

The way the reports works is taking fields from a model depending on the domain we declare.

The thing is that I need to get one2many or many2one fields in this report:

For example, if I call the field product_id for a quotation, it will return the first line from the Quotation but not others; also, I think it's not possible to call fields like this "product_id.id".

I wish to know if someone knows a way to do this, or a way to add a field that can be called in reports adding a new field like all_products containing -> product1, product2, etc.

Thanks beforehand.

Rodrigo

Avatar
Hylkää
Avatar
Que Nguyen
Paras vastaus

There is a work-around to archive this. You need to get field order_line from sale.order model, result is a string list of order_line ids (eg. "101,102,103"). Create another sheet tab to oe_browse from model sale.order.line, including field "id" in your query. Now you can do some spreadsheet command stuff (split, vlookup,...) to link those 2 sheet based on the id of order line.

Avatar
Hylkää
Avatar
Niyas Raphy (Walnut Software Solutions)
Paras vastaus

Hi,

For calling and printing the one2many or many2many fields, you have to iterate them over a for loop as there is chance/case of having multiple records in it. You might not have used or given for loop, which may result in singleton error.

You can see an example case of printing the one2many fields in report here, see this: Printing One2many fields in report

Thanks

Avatar
Hylkää
Rodrigo Robles
Tekijä

Very informative thanks. but it isn't what im looking for.

I'm new to Odoo & Python, so i'll try to explain it the best way I can.

I'm looking to get the products associated to a Quotation, Saler Order, Subscription, etc. in Google Spreadsheet module.

What I need is to be able to export something like this:

i.e. from CRM module -> for each quotation get all orders lines and link them.

Thanks & sorry for my english

Niyas Raphy (Walnut Software Solutions)

Hi,

if you have an object of the sale order in your hand, suppose sale.order(1) , then if you need to get the products in the sale order line, if you are in python,

for product in sale_order.order_line:

print("product", product) .

you can try something like this

Aiheeseen liittyviä artikkeleita Vastaukset Näkymät Toimenpide
One2many domain on the selection Ratkaistu
domain one2many selection odoo11
Avatar
Avatar
Avatar
5
heinäk. 22
6774
how can use output of function in domain of field? Ratkaistu
domain odoo11
Avatar
Avatar
Avatar
2
heinäk. 24
8697
Set default value for one of the one2many field - Odoo 11 Ratkaistu
one2many odoo11
Avatar
Avatar
1
tammik. 22
19408
how to add a one2many field in a form by a button click - odoo 11
one2many odoo11
Avatar
Avatar
3
heinäk. 19
6217
Update many2one field domain with respect to onchange of selection field in another model. Is it possible ?
domain odoo11
Avatar
Avatar
1
heinäk. 18
10321