Dear
I need in the Employee module to perform a search for a field in a table that has the following relationship:
class AiHrEmployee (models.Model):
_inherit = ['hr.employee']
collaborations_ids = fields.One2many ('hr.employee.collaboration.line', 'employee_id', "Collaboration activities")
class AiCollaborationActivityLine (models.Model):
_name = "hr.employee.collaboration.line"
employee_id = fields.Many2one ('hr.employee', 'Employee')
country_id = fields.Many2one ('res.country', 'Place of collaboration')
activity = fields.Char (string = "Activity of collaboration", size = 80)
time = fields.Integer (string = "Time", help = "Time of collaboration")
Country class:
_name = "res.country"
name = fields.Char ()
In the Employee view I want to do the search to show all the employees that have had collaboration in a certain country (country) that I enter.
For example:
Add Custom Filter
country
contains
cuba
I work with Odoo 11.0
I would appreciate any help in this respect.
Thanks you for advance!
Best regards,
Claudio
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
This question has been flagged
Yes Possible, all you need is the following
Step 1: In the Object: AiCollaborationActivityLine
define _rec_name = 'country_id' -- this set Name property for your custom object, which will be easier to perform default search.
Step 2: In the Object Hr.Employee.
Search View (XML) add field for collaborations_ids == Thus user can search directly
Same kind of features are also available in standard objects like Stock-Picking, Invoice -- Do refer for more ideas
Dear deep, thank you very much!
I also just received another solution variant sent by Jorge Tuñez:
<record id="ai_rh_gedic_studies_search" model="ir.ui.view">
<field name="name">ai.rh.gedic.studies.search</field>
<field name="model">hr.employee</field>
<field name="inherit_id" ref="hr.view_employee_filter"/>
<field name="arch" type="xml">
<xpath expr="//search" position="inside">
<field name="collaborations_ids" string="Activity of collaboration" filter_domain="[('collaborations_ids.country_id.name','ilike',self)]">
</field>
</xpath>
</field>
</record>
Enjoying the discussion? Don't just read, join in!
Create an account today to enjoy exclusive features and engage with our awesome community!
Sign upRelated Posts | Replies | Views | Activity | |
---|---|---|---|---|
|
1
Jan 19
|
5500 | ||
|
3
Nov 24
|
86 | ||
|
1
Jul 18
|
9369 | ||
|
0
Mar 15
|
3522 | ||
|
1
Oct 24
|
276 |