dynamically add new fields to a osv model depending on the number of records of another osv model in openerp?

Question

How to dynamically add new fields to a osv model depending on the number of records of another osv model in openerp? For example I have a model which is for planning purchases. I need to show total order qty that came in each shop.so i need to add new field each time a new record in sale.shop is created.

Omal Bastin · Accepted Answer

Use __init__ function of your class to dynamically add the sales shop to _columns .

class planning(osv.osv):
def __init__(self, pool, cr):
shop_ids = pool.get('sale.shop').search(cr,SUPERUSER_ID,[])
for shop in pool.get('sale.shop').browse(cr, SUPERUSER_ID,shop_ids):
self._columns['shop_qty_%s'%shop.id] = fields.float(
'%s Order Qty'%shop.name)
return super(planning,self).__init__(pool, cr)

Torsten Francke · Answer

This is impossible with the current osv model. And it is bad software design.

Better, add a new model: purchase_shop_quantity and make a one2many relation from your current model to the new one

Related Posts	Replies	Views
Dynamic selection fields in demo products selection dymanic_fields	3 May 21	2952
Odoo 17 Dashboard Customization - Dynamic Value in Gauge Chart dashboard dymanic_fields odoo17	0 May 24	1248
Impossible to create PDF with Dynamic Fields different from those present in the Odoo documentation [V17] pdf quotation builder dymanic_fields	0 Oct 24	852
(ODOO 10 How To) Compute domain / Dynamic Domain / set a domain based on a function or a field Solved domain domain_filter compute domains dymanic_fields	2 Sep 21	21581
Odoo how to dynamically create a weekly schedule mod-fri and mon-fri depending on a field inter value fields context wizards form_view dymanic_fields	0 Dec 15	5891

This question has been flagged

Enjoying the discussion? Don't just read, join in!