How to fetch one2many values in excel report ?
Odoo is the world's easiest all-in-one management software.
It includes hundreds of business apps:
- CRM
- e-Commerce
- Buchhaltung
- Lager
- PoS
- Project
- MRP
Diese Frage wurde gekennzeichnet
Hi,
If you have a record set, lets say object, then you can access one2many field value using object.field_name, as it is one2many field, iterate the result over a for loop, to get the value from each lines.
UPDT:
row = col = 0
for line in obj.moce_raw_ids
sheet.write(row, col, line.name, bold)
row += 1
Thanks & Regards
sheet.write(0, 0, obj.move_raw_ids.product_id.name, bold)
i add it like that and i think it works, but i get this error
ValueError: Expected singleton: product.product(2, 3, 4)
i this the error raised because i did't iterate using for loop,
but i'm wondering how to do it in excel report
see the updated answer
Diskutieren Sie gerne? Treten Sie bei, statt nur zu lesen!
Erstellen Sie heute ein Konto, um exklusive Funktionen zu nutzen und mit unserer tollen Community zu interagieren!
RegistrierenVerknüpfte Beiträge | Antworten | Ansichten | Aktivität | |
---|---|---|---|---|
|
1
Juli 22
|
2777 | ||
|
0
Juli 21
|
2052 | ||
Creating Excel Reports
Gelöst
|
|
1
Apr. 23
|
11572 | |
|
0
Nov. 22
|
2918 | ||
|
0
Sept. 21
|
2438 |