Skip to Content
Menu
This question has been flagged
1 Atsakyti
4073 Rodiniai

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.

Portretas
Atmesti
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.


Portretas
Atmesti
Related Posts Replies Rodiniai Veikla
1
vas. 24
1584
3
kov. 18
5921
1
bal. 20
5119
2
lapkr. 18
14719
1
birž. 18
3883