Is it possible filter list of x2many records in form view?
For example:
1)Show only first 5 lines.
2)Show only records, that have fields according to some domain.
Odoo is the world's easiest all-in-one management software.
It includes hundreds of business apps:
- CRM
- e-Commerce
- Boekhouding
- Voorraad
- PoS
- Project
- MRP
Deze vraag is gerapporteerd
3
Antwoorden
12911
Weergaven
Regarding the change of the limit of one2many fields please refer to question https://accounts.openerp.com/forum/Help-1/question/6627/
Regarding the filter I had the same requirement for one of our modules and I have solved it with the following steps. Assume that you have the following one2many field which you want to filter:
'line_ids': fields.one2many('your.model', 'script_id', 'Lines'),
Add a filter field to your model:
'ir_filter_id': fields.many2one('ir.filters', 'Additional Filter', domain=[('model_id', '=', 'your.model')]),Add a one2many function field to your model:
def _get_lines(self, cr, uid, ids, fields, args, context=None): line_obj = self.pool.get('your.model') res = {} for script in self.browse(cr, uid, ids): args = [('script_id', '=', script.id)] if script.ir_filter_id: args += eval(script.ir_filter_id.domain) line_ids = line_obj.search(cr, uid, args) res[script.id] = line_ids return res def _set_lines(self, cr, uid, id, name, value, inv_arg, context): line_obj = self.pool.get('your.model') for line in value: if line[0] == 1: # one2many Update line_id = line[1] line_obj.write(cr, uid, [line_id], line[2]) return True 'view_line_ids': fields.function(_get_lines, fnct_inv=_set_lines, string='Lines', relation="your.model", method=True, type="one2many"),Add the two fields to your form view
So you can filter your one2many field with any domain. You only have to be aware of the following points:
- The filter is stored in the DB and all users have the same filter - You have to save the form view so that the current filter becomes active
please help me for this issue..
http://help.openerp.com/question/8391/how-to-load-child-records-to-fields/
Big thanks for posting this, it worked nicely after adding also checks for line[0] being 0 or 2 (create or delete). I think there shouldn't have to be this much magic involved when wanting to filter a basic o2m field, though.
Thanks to Andreas Brueckl for idea with second functional 'view' field, example first case may be (filter first 5):
def _get_lines(self, cr, uid, ids, name, arg, context=None):
line_obj = self.pool.get('your.model')
res = {}
number = 5
for script in self.browse(cr, uid, ids, context=context):
line_ids = line_obj.search(cr, uid,[('script_id', '=', script.id)], limit=number)
res[script.id] = line_ids
return res
'view_line_ids': fields.function(_get_lines, relation="your.model", method=True, type="one2many"),
Thanks to Andreas for this detailed answer, the fnct_inv definition saved me some time. I would suggest for others that might need it, you can add:
elif line[0] == 0: # one2many create
self.create(cr, uid, line[2])
to the _set_lines function if you want to create new record.
Geniet je van het gesprek? Blijf niet alleen lezen, doe ook mee!
Maak vandaag nog een account aan om te profiteren van exclusieve functies en deel uit te maken van onze geweldige community!
Aanmelden| Gerelateerde posts | Antwoorden | Weergaven | Activiteit | |
|---|---|---|---|---|
|
5
sep. 20
|
13571 | ||
|
0
mrt. 15
|
4742 | ||
|
1
mrt. 15
|
6225 | ||
|
2
mrt. 15
|
8409 | ||
|
6
mei 24
|
72047 |
