İçereği Atla
Bu soru işaretlendi
automateddefault_getOdoo13.0
4 Cevaplar
4790 Görünümler
Avatar
himaOdoo

hello there, i want to get the value of the city field of the res.partner table filled up in a field of my custome module, 

 
partner_id = fields.Many2one('res.partner', string='Prestataire')


 def _get_default_city(self):
        return self.env['res.partner'].search([('name', '=', 'city')], limit=1).id

    ville = fields.Many2one('res.partner', string='Ville', default=_get_default_city, domain=[('name', '=', 'city')])

    @api.onchange('partner_id')
    def onchange_partner_id(self):
        self.ville = self.partner_id.city


but i keep receiving this error 


res = self._obj.execute(query, params)
psycopg2.DataError: invalid input syntax for integer: "Fremont"
LINE 1: ...sg" FROM "res_partner" WHERE "res_partner".id IN ('Fremont')
                                                             ^
Avatar
Vazgeç
himaOdoo
Üretici

yes i am trying to once i choose the partner_id name, the 'ville' filed to be filled in by the value of the city filed, i use often just the onchange function, i had used this code and it works just fine

employee_id = fields.Many2one('hr.employee', string="employé", required=True)

poste = fields.Many2one('hr.job', string='poste')

@api.onchange('employee_id')

def onchange_employee_id(self):

self.poste = self.employee_id.job_id

but i don't know why the same principe not working in this case

partner_id = fields.Many2one('res.partner', string="employé", required=True)

ville = fields.Many2one('res.partner', string='ville')

@api.onchange('partner_id')

def onchange_partner_id(self):

self.ville = self.partner_id.city

by the way i tried your code but i still got the same error

faOtools

self.ville is many2one; self.partner_id.city is char. It is not possible to apply char for many2one. You can't store string in database cell which requires integer.

self.poste is many2one; self.employee_id.job_id is also many2one. Both relate to the same object. Both relate assume integer value.

Although I didn't check my code running, the same error is hardly possible. Most probably, you haven't updated the module to change the field type.

himaOdoo
Üretici

yes exactly, i had to change the type of the ville field to char, thank any way sir

Avatar
faOtools
En İyi Yanıt

According to your code 'ville' is many2one field. So, it is id of related res.partner. 'city' is a char field. Thus, the line

self.ville = self.partner_id.city

tries to put into a partner reference char ('freemont'), while it anticipates integer (e.g. 12 - id of related partner).


I guess, what you are trying to achieve is to have inside ville name of the city? If, so you need to make it char:

def _get_default_city(self):
    # DO YOU REALLY HAVE THE PARTNER WHICH NAME IS city??
    return self.env['res.partner'].search([('name', '=', 'city')], limit=1).city

partner_id = fields.Many2one('res.partner', string='Prestataire')
ville = fields.Char(string='Ville' default=_get_default_city])
    
@api.onchange('partner_id')
def onchange_partner_id(self):
    self.ville = self.partner_id.city
Avatar
Vazgeç
İlgili Gönderiler Cevaplar Görünümler Aktivite
get default value of a field of other module
default_get Odoo13.0
Avatar
Avatar
2
Haz 20
6082
Odoo 13 server action: how to verify if a model action (button action) is satisfying a condition? Çözüldü
automated server_actions Odoo13.0
Avatar
Avatar
1
Oca 21
4486
Trying to automatically update analytic distribution in purchase order Çözüldü
automated
Avatar
Avatar
Avatar
3
Haz 25
3512
automation rules not saved
automated
Avatar
0
May 24
2296
Odoo 13. Don't close a wizard when Click a button Çözüldü
Odoo13.0
Avatar
Avatar
Avatar
Avatar
4
May 24
13988