Skip to Content
Menu
This question has been flagged
1 Reply
2971 Views

How can I read from a related field, all sale.order objects which are on 'draft' state?


I've tried this:


class account_budget_bsi(models.Model):

    _name = 'account.budget.bsi'

    _inherit = ['crossovered.budget', 'sale.order', 'stock.location', 'stock.move', 'purchase.order']

    sale_order = fields.Many2one('sale.order')

    sales_bsi = fields.Many2one('sale.order' , related="sale_order.state.draft", string="Sales Planned")


But it's not working as it seems.


Any idea on how to achieve this?


I mean, the issue is that all the sale orders must be on 'draft' state, I know that maybe the Many2one related field isn't working because 'state' is a Selection one, but can't figure out how to load it like that.

Avatar
Discard
Best Answer

Hi,

Related fields are used to show value of a field in a many2one.

If you want to filter many2one according to value set domain for your many2one field

sales_bsi = fields.Many2one('sale.order', string='Sales Planned', domain=[('state', '=', 'draft')])

Or if you are trying to view all sale order in draft state you can add it as a many2many field and give default value for that field.


Avatar
Discard
Related Posts Replies Views Activity
1
Feb 24
443
3
Mar 18
4753
1
Apr 20
4023
2
Nov 18
13305
1
Jun 18
2562