ValueError: ValueError singleton

Question

Hello,
In below code, product_id is my Many2many field of product1 table and price is a field of that table When i select more than one product in Many2many field, I get this error :  ValueError: Expected singleton:
product1.product1(2, 4)   . can anyone help me.
Thanks in advance.

Code:

total = fields.Float( "Total" , readonly = True , compute = "count" )
product_id = fields.Many2many( 'product1.product1' , string = "Products" )
@api.onchange ( 'product_id' )    def  count ( self ):      for

Mitul Shingala · Accepted Answer

Hello,
in your code product_id is many2many field. and into method line: i.product_id.price, you get the multiple product ids. that's why you get singleton error.make below change into your code:

@api.onchange('product_id')
def count(self):
for i in self:
total = 0
*for prod in i.product_id:**
**            total += prod.price**
*        i.total = total

Dhaval Desai · Answer

Hi Ruturaj,
ValueError: Expected singleton:  product1.product1(2, 4)  it means  product_id  return multiple records you can not directly assign values.
*Example:*
@api.onchange('product_id')
def count(self):
for i in self:
total = 0
for p in i.product_id:
total += p.price
i.total = total
Thank You.

Ruturaj Chavda · Answer

Gerelateerde posts	Antwoorden	Weergaven
Error with singleton value valueerror singleton	4 mrt. 24	2718
Odoo 11.0 ValueError: Expected singleton on create operation Opgelost create valueerror singleton	4 dec. 19	6232
Wrong value for crm.lead.service: <odoo.fields.Selection> valueerror	2 jul. 23	3364
ValueError: Expected singleton (odoo 14) Opgelost expected valueerror singleton v14	1 dec. 20	15500
ValueError: Wrong value for medical.teeth.treatment.state: 'termin\xe3\xa9 valueerror	5 feb. 20	9956

Deze vraag is gerapporteerd

Geniet je van het gesprek? Blijf niet alleen lezen, doe ook mee!