This question has been flagged
1 Reply
6937 Views
ormsearchpython3envodoo12
Avatar
Mohamed Fouad (personal)

i made a model it called part number as examble it contains the part number as name field and car and model fields, also in product.template view i'am added thos tow fields car and model and a button with method to print the part number which contins the same self car and model it's works well but it givs no result if i remove search conditions it print all results this the code

class autopart(models.Model):
_inherit = 'product.template'  @api.multi
@api.depends('car','model')
def partnum(self):
    part=self.env['part_num'].search([('model_id', '=', 'model'),('car_id', '=', 'car')])
    print(part)
    pass

car = fields.Many2one(comodel_name="cars", store=True, string="Car", ondelete='restrict', required=False, )
model = fields.Many2one(comodel_name="models", store=True, string="Model", ondelete='restrict', required=False,default='', domain="[('car','=', car )]")

and this is the part num model

class part_num(models.Model):
_rec_name = 'name'
_name = 'part_num'  name = fields.Char(string="name",required=True)

car_id = fields.Many2one(comodel_name="cars", string="car", required=False, )
model_id = fields.Many2one(comodel_name="models", string="model", required=False, )


Avatar
Discard
Avatar
Sudhir Arya (ERP Harbor Consulting Services)
Best Answer

You just need to use the fields of product template to search the parts based on selected Car and Model in the product template and search for the related parts.

Try following code:

@api.multi
def partnum(self):
    print (self.car, self.model)
    parts = self.env['part_num'].search([('model_id', '=', self.car.id),('car_id', '=', self.model.id)])
    print (parts)



Avatar
Discard
Mohamed Fouad (personal)
Author

it also print empty in parts even if true conditions

Sudhir Arya (ERP Harbor Consulting Services)

It should work without any issue. Make sure the car and model are selected in the product template.

Also make sure that parts has same combination as product template for the "car and model".

Mohamed Fouad (personal)
Author

Thank you it works well dear

Mohamed Fouad (personal)
Author

pleare change values in search conditions