Odoo Help
Odoo is the world's easiest all-in-one management software. It includes hundreds of business apps:
CRM
|
e-Commerce
|
Accounting
|
Inventory
|
PoS
|
Project management
|
MRP
|
etc.
How to filter a related field?
Hi,
I have a 3 way relation that i show in my form using a fields.related object.
'event_training_id':fields.related('events_ids_registration', 'event_id', 'registration_ids', relation='event.event', type='one2many', string='Event'
This show me the events in wich the hr.employee is registered, but as the hr.employee can be registered in a bunch of objects, i want to show only those that have a boolean field called is_training marked as True.
My doubt is if this is possible, as the field is_training is within the object event.event, and my related field in hr.employee. I tried with a domain="[('is_training','=',True)]" but to no luck.
Does anyone know if this is achievable? Thanks in advance.
Francesco OpenCode
Italian Odoo (OpenERP) Modules Developer LINKEDIN: http://www.linkedin.com/in/francescoapruzzese
The related field are filtrable only if storeparameter is True. Related are, basically, function field and if them aren't stored, OpenERP can't search (and filter) them.
I tried adding the store=True to the related field, but then it gives me the error "ProgrammingError: column hr_employee.event_training_id does not exist" and if i remove the store=True it shows me field without issue. Isn't this the exact opposite behaviour of the store attribute?
About This Community
This platform is for beginners and experts willing to share their Odoo knowledge. It's not a forum to discuss ideas, but a knowledge base of questions and their answers.
RegisterOdoo Training Center
Access to our E-learning platform and experience all Odoo Apps through learning videos, exercises and Quizz.
Test it nowQuestion tools
Stats
| Asked: 6/25/13, 4:47 PM |
| Seen: 3626 times |
| Last updated: 3/16/15, 8:10 AM |