This question has been flagged
3 Replies
7689 Views
domainerrorfilteringdynamic
Avatar
Erhuvwu Akpobaro

I have a many2one field which i want to have a dynamic domain filter on : 

but i want start with something basic by just passing a variable through a integer in a function:

class mm_control_zone(osv.osv):

_name = "mm.control.zone"

_rec_name = "zone_id"

_columns = {

'zone_id':fields.many2one('product.category' , 'Zone')

}

def get_domain_useer_id(self,cr,uid,ids,context=None):

lids = 20

return domain = {'product_category':[('id', '=', lids)]}


xml:

<field name="zone_id" on_change="get_domain_useer_id()"/>


So far the function doesn't work as my field is not being filtered.


is there a better way of having a dynamic filter ?

Avatar
Discard
Avatar
Zbik
Best Answer

Try like this:

return {'domain': {'product_category':[('id', '=', lids)]}}

Avatar
Discard
Avatar
Niyas Raphy (Walnut IT)
Best Answer

Hi,

Other than returning domain in onchange method, you can use the web domain field module from oca for the same:  Web Domain Field


See this: Return Dynamic Domain For Field In Odoo


How to use:

.. code-block:: xml

   <field name="product_id_domain" invisible="1"/>
   <field name="product_id" domain="product_id_domain"/>


.. code-block:: python

   product_id_domain = fields.Char(
       compute="_compute_product_id_domain",
       readonly=True,
       store=False,
   )

   @api.multi
   @api.depends('name')
   def _compute_product_id_domain(self):
       for rec in self:
           rec.product_id_domain = json.dumps(
               [('type', '=', 'product'), ('name', 'like', rec.name)]
           )

Returning domain from the onchange function: How To Give Domain For A Field Based On Another Field

Thanks

Avatar
Discard
Avatar
Erhuvwu Akpobaro
Author Best Answer

Hello @ zbik thanks for your help it worked , what if i want to return another selection id from another table .

so far i have tried :


def get_domain_useer_id(self,cr,uid,ids,context=None):

d_obj = self.pool.get('mm.control')

lids = d_obj.browse(cr,uid,ids, context=context)

lids2 = lids.parent_zone_id

return {'domain': {'zone_id':[('id', '=', lids2)]}}

the model which i want to get the selection from :


class mm_control(osv.osv):

_name = "mm.control"

_rec_name = "company"

_columns = {

'parent_zone_id':fields.many2one('product.category','Parent Zone', domain="[('id', 'child_of' , 3)]" , required=True , help="Parent zone "),

'company':fields.many2one('res.company' , 'Company', domain="[('company_type', '=', 'Property Company')]", required=True, select=1 ) ,

'rental_split': fields.float('Rent', help="Service charge split of total rent amount"),

'maintenance_split': fields.float('Maintenance', help="Rent split of total rent amount"),

'service_split': fields.float('Service', help="Service charge split of total rent amount"),

'mm_control_zone_id': fields.one2many('mm.control.zone' , 'zone_id','Zones' ),

 

}

how can i go about achieving this ?

Avatar
Discard