Skip to Content
Menu
This question has been flagged
2 Replies
10308 Views

hi,

I am creating a call log module , and i need to automatically get the partner information by the given number ie. the system have to automatically search and fetch the partner and assign it to a field .

Somebody please help me with the python code , my code is :


customer_number = fields.Char(string='Customer Number', track_visiility='onchange', onchange='get_partner()', store=True)
customer_id = fields.Many2one('res.partner', string='Customer', track_visibility='onchange',index=True,
help="Linked partner (optional). Usually created when converting the lead.", store=True)

#--------------------------------------------------
# Api s
#--------------------------------------------------

@api.onchange('customer_number')

def get_partner(self):
if self.customer_number:
partner = self.env['res.partner'].search_read([('self.customer_number', 'ilike', 'self.phone')])
self.customer_id = partner
return self.customer_id
Avatar
Discard
Best Answer

Hello,

You need to remove quotes from self.phone and should use search method to find the Parther.

Ex:

self.customer_id = self.env['res.partner'].search(['|', ('phone', 'ilike', self.customer_number), ('mobile', 'ilike', self.customer_number)], limit=1).id


Avatar
Discard

Also, the 'self.customer_number' in the search has to be changed to 'phone' or 'mobile'

Thanks for drawing the attention. I corrected the code now.

Best Answer

Hi,

Update the onchange function like this,

@api.onchange('customer_number')
def get_partner(self):
if self.customer_number:
partner = self.env['res.partner'].search([('phone', 'ilike', self.customer_number)], limit=1)
if partner:
self.customer_id = partner.id


Thanks

Avatar
Discard
Related Posts Replies Views Activity
7
Jul 19
39461
0
Apr 19
2216
0
Oct 19
3164
0
Aug 18
5894
1
Dec 17
2579