Skip to Content
This question has been flagged
1 Reply
470 Views
Avatar
Christopher Thomas

I have a field in my subcontractor BOM that just displays zero (I believe 0 is the default of an integer field) but there is no label, it's completely blank so I haven't got a clue what field it is.

Is there a way in Odoo Studio to view the actual SQL table column name associated with that field so I know what it is? If you click on the field there is no way of seeing where the data came from.


Really what I'm missing in Odoo Studio is a list of fields that are currently IN the view. There is already a way of seeing what fields are NOT in the view (Existing Fields), but there should really be a way of seeing what views ARE in the view already.


Thanks.


Avatar
Discard
Christopher Thomas
Author

You're correct, it was the attachments. Thought you had to use Odoo Studio to see that but good to know how it works with developer mode.

Thanks a lot!

Avatar
Ray Carnes (ray)
Best Answer

It is probably the number of attachments related to the component on that line:

If you activate Developer Mode and hover over the name of a field with a Header Label, you can then use the Debug Menu to open the Form View and find the name(s) of the fields in that part of the View:




Note that when you find this field in the Fields Menu, you will see it is not stored, so not available as a SQL column like other stored fields (it is instead calculated on the fly via Python Code).

    @api.depends('product_id')
    def _compute_attachments_count(self):
        for line in self:
            nbr_attach = self.env['product.document'].search_count([
                '&', '&', ('attached_on_mrp', '=', 'bom'), ('active', '=', 't'),
                '|',
                '&', ('res_model', '=', 'product.product'), ('res_id', '=', line.product_id.id),
                '&', ('res_model', '=', 'product.template'), ('res_id', '=', line.product_tmpl_id.id)])
            line.attachments_count = nbr_attach


https://github.com/odoo/odoo/blob/19.0/addons/mrp/models/mrp_bom.py#L725

https://github.com/odoo/odoo/blob/19.0/addons/mrp/models/mrp_bom.py#L743

Avatar
Discard