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

関連投稿	返信	ビュー
Error with singleton value valueerror singleton	4 3月 24	1628
Odoo 11.0 ValueError: Expected singleton on create operation 解決済 create valueerror singleton	4 12月 19	5320
Wrong value for crm.lead.service: <odoo.fields.Selection> valueerror	2 7月 23	2351
ValueError: Expected singleton (odoo 14) 解決済 expected valueerror singleton v14	1 12月 20	14484
ValueError: Wrong value for medical.teeth.treatment.state: 'termin\xe3\xa9 valueerror	5 2月 20	9067

この質問にフラグが付けられました

ディスカッションを楽しんでいますか？読むだけでなく、参加しましょう！