Skip ke Konten
Pertanyaan ini telah diberikan tanda
automateddefault_getOdoo13.0
4 Replies
4795 Tampilan
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
Buang
himaOdoo
Penulis

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
Penulis

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

Avatar
faOtools
Jawaban Terbai

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
Buang
Post Terkait Replies Tampilan Aktivitas
get default value of a field of other module
default_get Odoo13.0
Avatar
Avatar
2
Jun 20
6090
Odoo 13 server action: how to verify if a model action (button action) is satisfying a condition? Diselesaikan
automated server_actions Odoo13.0
Avatar
Avatar
1
Jan 21
4508
Trying to automatically update analytic distribution in purchase order Diselesaikan
automated
Avatar
Avatar
Avatar
3
Jun 25
3530
automation rules not saved
automated
Avatar
0
Mei 24
2304
Odoo 13. Don't close a wizard when Click a button Diselesaikan
Odoo13.0
Avatar
Avatar
Avatar
Avatar
4
Mei 24
14010