How to update a record from another function

Question

I'm trying to update the body field from the payrun_chatter_log() but it won't update. any idea on how to do this? This is what I did:

def payrun_chatter_log(self):
        subtype = self.env['mail.message.subtype'].search([('id','=', '2')])
    
        vals = {
            'date': fields.datetime.now(),
            'email_from': self.env.user.email_formatted,
            'author_id': self.env.user.id,
            'message_type': 'notification',
            'subtype_id': subtype.id,
            'is_internal': True,
            'model': 'custom.module',
            'res_id': self.id,
            'body': 'Test'
        }
        self.env['mail.message'].create(vals)
    
def custom_button(self):
        chatter = self.env['mail.message'].search([('res_id', '=', self.id)])
        message = 'Custom Message here'
        chatter.update({'body': message})
        return super(CustomModule, self).custom_button()

Move vals to __init__(self) and change when needed. – Shantanu Tripathi Jun 24 '22 at 05:28 — Shantanu Tripathi, Jun 24 '22 at 05:28

score 0 · Answer 1 · answered Jun 25 '22 at 13:39

Your below line of code in custom_button will return multi record because res_id will be repeated for more than one model

chatter = self.env['mail.message'].search([('res_id', '=', self.id)])

You need to add the model to search:

chatter = self.env['mail.message'].search([('model', '=', self._name), ('res_id', '=', self.id)])

score 0 · Answer 2 · answered Jun 26 '22 at 11:20

The message body should be updated, you need to refresh the page to see the changes.

Try to return the following client action:

return {
    'type': 'ir.actions.client',
    'tag': 'reload',
}

The chatter has an One2many relation to mail.message model. Your function will update all messages

How to update a record from another function

2 Answers2