Skip to Content
Menu
This question has been flagged
5 Replies
5019 Views

I try to figure how I can show a restricted list of orders, purchases or invoice based on a field I added in the product model, stock_owner_id. He should see only records related to his allowed_stock_owner_ids.

Am I forced to copy stock_owner_id from product.template to sale.order.line to sale.order to apply my domain filter? Is there another way around?

Here are my models:

class User(models.Model): 
    _inherit = 'res.users'
    
    current_stock_owner_id = fields.Many2one('res.partner', string='Current Stock Owner')
    allowed_stock_owner_ids = fields.Many2many('res.partner', 'res_partner_users_rel', 
                                       string='Stock Owners',
                                       domain="[('stock_owner','=',True)]")

class ProductTemplate(models.Model): _inherit = 'product.template' stock_owner_id = fields.Many2one('res.partner', string='Stock Owner',     domain="[('stock_owner','=',True)]")

Avatar
Discard

you may need to provide domain in a RETURN.... which returns a model ,say 'purchase.order' and define that domain based on your condition

Author

Abdul, can you give an example?

please check the question that i have asked "pass filtered purchase orders"...

Author

That doesn't help me at all sorry. I don't see the link between your case and mine. My ultimate goal is to create record rules...

Author Best Answer

Got it! Here is the record rule I need :)

 <record id="isolate_stock_owners_sale_order_rule" model="ir.rule">
        <field name="name">Isolate Stock Owner Sale Order</field>
        <field name="model_id" ref="model_sale_order"/>
        <field eval="True" name="global"/>
        <field name="domain_force">[('order_line.product_tmpl_id.stock_owner_id', '=', user.allowed_stock_owner_ids.id)]</field>
    </record>
Avatar
Discard

if u don't mind will u please explain,how record rule works??currently i am familiarised with only two types of records.ir.ui.view and action.

Author

This allow us to define rules tu access records based on a domain filter. As you can see the domain filter allow dot notation on the left and right side. Check the documentation because when executed on the client side, domain filter doesn't allow dot notation on the left side if I'm not mistaken.

Related Posts Replies Views Activity
1
May 24
1309
1
Nov 22
3301
2
Jul 22
2103
2
May 18
8877
2
Jul 17
5418