Overslaan naar inhoud
Je moet geregistreerd zijn om te kunnen communiceren met de community.
Alle posts Personen Badges
Labels (Bekijk alle)
odoo accounting v14 pos v15
Over dit forum
Deze vraag is gerapporteerd
pythonsingletonodoo12
3 Antwoorden
5697 Weergaven
Avatar
BulldogSoft, Pamela Castaneda

I have this function that does its job, but i tried to make the field store=True and when i update it gives me and expected singleton error Expected singleton: project.project(2, 3, 1).

 this is my code.

sum_pre = fields.Float(string="Total Presupuesto Aprobado", required=False, compute='presupuesto_sum')

@api.depends('tasks.sum_total_cost')
def presupuesto_sum(self):
    etapa = self.env['project.task'].search([('project_id', '=', self.id), ('stage_id', '=', 'Presupuesto Aprobado')])
    for data in etapa:
        if data:
            self.sum_pre = round(sum(etapa.mapped('sum_total_cost')), 2)

Someone knows how to resolve it or where i have the error, Thanks!

                  Avatar
                  Annuleer
                  Avatar
                  Niyas Raphy (Walnut Software Solutions)
                  Beste antwoord

                  Hi,

                  Can you update the function with a for loop like this and see,

                  def presupuesto_sum(self):
                      for rec in self:
                          etapa = self.env['project.task'].search(
                              [('project_id', '=', rec.id), ('stage_id', '=', 'Presupuesto Aprobado')])
                          for data in etapa:
                              if data:
                                  rec.sum_pre = round(sum(etapa.mapped('sum_total_cost')), 2)

                  Thanks

                  Avatar
                  Annuleer
                  BulldogSoft, Pamela Castaneda
                  Auteur

                  Thanks Niyas Raphy, this works fine

                  Avatar
                  Baiju KS
                  Beste antwoord

                  Hi Pamela Castaneda,

                  Now you are using the "sum_pre" field in the form view only, right?

                  In this case without attribute "store=True", it's calculating the value on the fly when you are opening the form. In this case, the self in 

                  etapa = self.env['project.task'].search([('project_id', '=', self.id), ('stage_id', '=', 'Presupuesto Aprobado')])

                  will be a single record of the current form. So it will work fine.

                  But when you give the attribute "store=True" and update, it will try to compute and store the value of field "sum_pre" in all the existing records at once, now the self in the above code will be a recordset and it will throw the Expected singleton error as it is expecting a single record in self.

                  To avoid this you have to iterate the self, using the for loop like

                          for project in self:
                  You will get the same error if you use the "sum_pre" field in tree view without attribute "store=True"

                  Hope this helps.
                  Avatar
                  Annuleer
                  BulldogSoft, Pamela Castaneda
                  Auteur

                  Thanks for the explanation, it is very useful information for me.

                  Avatar
                  Russ Schneider
                  Beste antwoord

                  Somewhere you're pulling in three project ids.  Some variable.  Perhaps sum_total_cost?


                  Avatar
                  Annuleer
                  Gerelateerde posts Antwoorden Weergaven Activiteit
                  Create Journal Entries whit code Opgelost
                  python odoo12
                  Avatar
                  Avatar
                  Avatar
                  		2
                  aug. 25
                  		10831
                  Two many2many fields related to each other inside one model Opgelost
                  python odoo12
                  Avatar
                  		1
                  jun. 22
                  		10141
                  how to make invoice date field readonly false for administrator after validating invoice in odoo12?
                  python odoo12
                  Avatar
                  Avatar
                  		1
                  sep. 21
                  		4703
                  Update tax in invoice line
                  python odoo12
                  Avatar
                  		0
                  aug. 21
                  		95
                  How do I find Average Cost Function?
                  python odoo12
                  Avatar
                  		0
                  jul. 21
                  		172