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

Publications associées	Réponses	Vues
Error with singleton value valueerror singleton	4 mars 24	1759
Odoo 11.0 ValueError: Expected singleton on create operation Résolu create valueerror singleton	4 déc. 19	5469
Wrong value for crm.lead.service: <odoo.fields.Selection> valueerror	2 juil. 23	2523
ValueError: Expected singleton (odoo 14) Résolu expected valueerror singleton v14	1 déc. 20	14626
ValueError: Wrong value for medical.teeth.treatment.state: 'termin\xe3\xa9 valueerror	5 févr. 20	9204

Cette question a été signalée

Vous appréciez la discussion ? Ne vous contentez pas de lire, rejoignez-nous !