Skip to Content
This question has been flagged
domain_filterodoo11
3 Replies
17077 Rodiniai
Portretas
mitra safari

Hello Odoo community! 

i want filter domain of product_id (many2one field) by some condition ,to do that i write compute field and in xml code , iuse compute field as domain , but it did not work . can anyone help me???

in  .py

def _menu(self):

day = self.env['lunch.menu'].search([]).mapped('day')
order_day = self.env['lunch.order'].search([]).mapped('date')
day_name = datetime.datetime.now().strftime('%A')
for rec in self:
    for d in range (0,len(day)):
        if  day[d] == day_name:
            menu = self.env['lunch.menu'].search([('day' ,'=' ,day_name)]).mapped('product.id')
            rec.product_c = menu 


product_c = fields.Char('CProduct', compute = '_menu')
product_id = fields.Many2one('lunch.product', 'Product', required=True)


in  XML:

<field name='product_c' >

<field name='product_id' domain='product_c'>


Portretas
Atmesti
Portretas
Athira Ravindran
Best Answer

Hi

Try this...



def _menu(self):

res = {}
res['domain'] = {'field_name': [('id', '=', value)]}
return res

day = self.env['lunch.menu'].search([]).mapped('day')
order_day = self.env['lunch.order'].search([]).mapped('date')
day_name = datetime.datetime.now().strftime('%A')
for rec in self:
    for d in range (0,len(day)):
        if  day[d] == day_name:
            menu = self.env['lunch.menu'].search([('day' ,'=' ,day_name)]).mapped('product.id')
            rec.product_c = menu 


product_c = fields.Char('CProduct', compute = '_menu')
product_id = fields.Many2one('lunch.product', 'Product', required=True)

Portretas
Atmesti
Portretas
Usman Farzand
Best Answer

if you want to change your domain base on product_id(many2one) field then please use on change method for it base on Product_id(many2one)

then you can easily return domain like 

res = {}
res['domain'] = {'field_name': [('id', '=', value)]}
return res
Portretas
Atmesti
Portretas
Rishan Malaka
Best Answer

​Hi,

This will be helpful for you - https://www.linkedin.com/pulse/how-set-dynamic-domain-filter-many2one-field-odoo-rishan-malaka/

Portretas
Atmesti
mitra safari
Autorius

hi @Rishan Malaka

thanks for your reply .i write on_change function as you said but it did not work can you help me?

@api.onchange('date')

def _onchange_menu(self):

res={}

self.write({'test1':'ok'})

day = self.env['lunch.menu'].search([]).mapped('day')

order_day = self.env['lunch.order'].search([]).mapped('date')

day_name = datetime.datetime.now().strftime('%A')

for d in range (0,len(day)):

if day[d] == day_name:

menu = self.env['lunch.menu'].search([('day' ,'=' ,day_name)]).mapped('product.id')

res['doamin']={'product_c':[('id','in',menu.ids)]}

return res

Related Posts Replies Rodiniai Veikla
[11.0] How can i pass self value to domain
domain domain_filter odoo11
Portretas
0
rugp. 19
5241
How to filter the domain of a selectbox depending on the value of another selectbox Solved
many2one domain_filter odoo11
Portretas
Portretas
1
lapkr. 18
7205
Domain filter odoo11 manyToOne
many2one domain_filter odoo11
Portretas
5
vas. 18
6198
How to enable Track Inventory > By Quantity through Python controller
odoo11
Portretas
1
vas. 26
62
create backorder odoo after validate purchase shipment ?
odoo11
Portretas
0
bal. 26
14205