Skip to Content
This question has been flagged
filterfieldsrelated
1 Reply
15934 Views
Avatar
Khalid Masood

Hi,

I have three fields in three different classes which are related in a chain: District, Sub District, Area

Area is linked to Sub District, Sub District is Linked to District.

class sna_district(osv.osv): _name="sna.district" _description="Define districts" _columns={ 'name':fields.char('District Name',size=64,required=True) }

class sna_sub_district(osv.osv): _name="sna.sub.district" _description="Define sub districts" _columns={ 'name':fields.char('Sub District Name',size=64,required=True), 'sub_district_id': fields.many2one('sna.district','District Name',select=True,required=True,ondelete="restrict") }

class sna_area(osv.osv): _name="sna.area" _description="Define areas" _columns={ 'name':fields.char('Area Name',size=64,required=True),
'area_type': fields.selection(area_type_lov,'Area Type',required=True), 'sub_district_id':fields.many2one('sna.sub.district','Sub District Name',size=64,required=True), 'district_id':fields.related('sub_district_id','sub_district_id',readonly=True,type='many2one',relation='sna.district',string='District Name'),
}

Above three are working fine.

In another class, user need to specify all three fields, user selects the 'District' in the first field, based on the 'District' selected, system should display the related 'Sub Districts' only in the second field (the ones which are linked to selected 'District'), based on the 'Sub District' selected by the user (from filtered list), system should display the related 'Area' only in the third field (the ones which are linked to selected 'Sub District').

Below is what I am trying but it looks wrong and therefore not working:

class sna_aor_super(osv.osv): _name="sna.aor.super" _description="Area of Registration Super" _columns={ 'district_id': fields.many2one('sna.district','District',select=True,required=True,ondelete="restrict"), 'sub_district_id':fields.related('district_id','district_id',readonly=True,type='many2one',relation='sna.sub.district',string='Sub District'), 'area_id':fields.related('sub_district_id','sub_district_id',readonly=True,type='many2one',relation='sna.area',string='Area'), }

Help will be much appreciated.

Thanks

Avatar
Discard
Avatar
Petar Najman
Best Answer

Hi Khalid,

If you want to apply that kind of filtering you should use domains on fields instead of using related fields

class sna_aor_super(orm.Model): 
    _name = "sna.aor.super" 
    _description = "Area of Registration Super"
    _columns = { 
        'district_id' : fields.many2one('sna.district','District', select=True, required=True, ondelete="restrict"), 
        'sub_district_id' : fields.many2one('sna.sub.district', 'Sub District', domain="[('sub_district_id', '=', district_id)]", select=True, required=True),
        'area_id' : fields.many2one('sna.area', 'Area', domain="[('sub_district_id', '=', sub_district_id)]", select=True, required=True),
    }

Regards, Petar

Avatar
Discard
Khalid Masood
Author

Thank you for the help. Much appreciated.

Petar Najman

You are very welcome Khalid :)

Related Posts Replies Views Activity
Date is less than 3 months
filter fields
Avatar
0
जुल॰ 15
4260
How to set the default value without a related field?
fields default related
Avatar
Avatar
1
अक्तू॰ 21
4510
Please Help me with this KeyError problem!
fields related keyerror
Avatar
0
जन॰ 17
8796
is there any way to pass values from functional field to a related field????
fields on_change related
Avatar
Avatar
1
अक्तू॰ 15
4993
Field related - one sided relation
fields related change
Avatar
Avatar
1
मार्च 15
7502