Siirry sisältöön
Sinun on rekisteröidyttävä, jotta voit olla vuorovaikutuksessa yhteisön kanssa.
Kaikki kirjoitukset Ihmiset Merkit
Tunnisteet (Näytä kaikki)
odoo accounting v14 pos v15
Tietoa tästä foorumista
Tämä kysymys on merkitty
1 Vastaa
483 Näkymät
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
Hylkää
Christopher Thomas
Tekijä

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)
Paras vastaus

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
Hylkää