Odoo on write() method check many2many relation

Question

I have 2 classes:

class my_request(models.Model):

    _name = 'my.request'
    _inherit = ['mail.thread', 'ir.needaction_mixin']

    supply_ids  = fields.Many2many(comodel_name='supply.conditions',
                                              relation='purchase_supply_rel',
                                              column1='purchase_requests_id', column2='supply_conditions_id',
                                              string='Supply Conditions')

and

class SupplyConditions(models.Model):
    _name = 'supply.conditions'

vendor = fields.Char(string='Vendor', required=True)
quantity = fields.Char(string='Quantity', required=True)
request_id = fields.Many2one('my.request', 'My request')
name = fields.Many2one('my.request.line', string='Product', required=True)
currency_id = fields.Many2one('res.currency', string='Currency', default=_get_default_currency)
supply_rel_id = fields.Boolean(string='Relation field', default=False)

my.request class part of form view xml:

<page string="Order">
      <field name="supply_ids" domain="[('purchase_id', '=', id)]"/>
</page>

When I select values from my.request form view and click on Save button I call write() method and at that time insert m2m values (if there is selected values) into relational table (purchase_supply_rel).

I want to add check if purchase.request id is in purchase_supply_rel table in purchase_requests_id field when I click on Save button. My function. Changes after # my new code coment:

@api.multi
def write(self, vals):
    res = super(PurchaseRequest, self).write(vals)
    for request in self:
        if request.state != 'draft':
        if vals.get('assigned_to'):
            self.message_subscribe_users(user_ids=[request.assigned_to.id])
    # my new code
    test = self.env['purchase.request'].search([(self.id,'in','supply_ids')])
    _logger.warning("test " + str(test));
    return res

But I got an error:

  File "/opt/odoo/openerp/osv/expression.py", line 586, in check_leaf
    raise ValueError("Invalid leaf %s" % str(self.leaf))
ValueError: Invalid leaf (348, 'in', 'supply_ids')

How else I can check this? And what I am doing wrong?

UPDATE:

I need to get test value smth like this: purchase_request(245,352) 245,352 - ids of purchase.request class

score 2 · Answer 1 · answered Jun 15 '17 at 13:51

2

You can not add dynamic value in domain in place of field name. Domain is a list of tuples. Domain contains three portions in tuple.

Domain:

[('field_name','operator','values')]

So dynamic value is not allowed in field name in domain.

@api.multi
def write(self, vals):
    res = super(PurchaseRequest, self).write(vals)
    for request in self:
        if request.state != 'draft':
        if vals.get('assigned_to'):
            self.message_subscribe_users(user_ids=[request.assigned_to.id])
    # my new code
    test = self.env['purchase.request'].search([('supply_ids','in',self.ids)])
    _logger.warning("test " + str(test));
    return res

answered Jun 15 '17 at 13:51

Emipro Technologies Pvt. Ltd.

14,598
5
45
75

Thank you. After changed I don't get error message but something is still wrong. The problem is that when I call write() method, test value I got emplty: purchase.request() although there is data on the relational table (purchase_supply_rel). So I have no idea how else can I check is there any value on relational table... – fueggit Jun 16 '17 at 06:15
Please share model structures of all models. – Emipro Technologies Pvt. Ltd. Jun 16 '17 at 13:54
What exacly do you mean? Do you want to look at init file and manifest? Now I updated fields used in supply.conditions in my question. – fueggit Jun 18 '17 at 17:14
I tried another method: test = self.supply_ids.ids if test > 0 then I get what I need (check if value is in relational m2m table) – fueggit Jun 19 '17 at 11:55
ohh you want to save that M2m field data into relational model while you save my.request record ? – Emipro Technologies Pvt. Ltd. Jun 19 '17 at 12:10
I want to check if my.request record is saved in relational m2m table – fueggit Jun 19 '17 at 12:19
in general M2m field will take care of this by default. – Emipro Technologies Pvt. Ltd. Jun 19 '17 at 12:43

Odoo on write() method check many2many relation

1 Answers1