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
- Boekhouding
- Voorraad
- PoS
- Project
- MRP
Deze vraag is gerapporteerd
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
Geniet je van het gesprek? Blijf niet alleen lezen, doe ook mee!
Maak vandaag nog een account aan om te profiteren van exclusieve functies en deel uit te maken van onze geweldige community!
AanmeldenGerelateerde posts | Antwoorden | Weergaven | Activiteit | |
---|---|---|---|---|
|
1
jul. 22
|
2763 | ||
|
0
jul. 21
|
2040 | ||
Creating Excel Reports
Opgelost
|
|
1
apr. 23
|
11530 | |
|
0
nov. 22
|
2876 | ||
|
0
sep. 21
|
2425 |