Our users are looking for a way to search a very busy pipeline for all opportunities matching not on the company name but on the name of contacts within the company.
Is there any good way to achieve this in V13 Enterprise?
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
1
Reply
2165
Views
Try something like this Custom View:
(line 6 is the new search domain - adding the child records of the Opportunity partner_id to the search)
<field name="partner_id" position="replace">
<field name="partner_id" operator="child_of" string="Customer"
filter_domain="['|', '|', '|', '|',
('partner_id.child_ids', 'ilike', self),
('partner_id', 'ilike', self),
('partner_name', 'ilike', self),
('email_from', 'ilike', self),
('contact_name', 'ilike', self)]"/>
</field>
With a Company called Acme Smoked Fish with four Contacts:
...if you create an Opportunity for Acme Smoked Fish:
...you will then be able to find it by entering any of the Contact names as well as the Company name.
or 
or 
This works very well - thank you!
Enjoying the discussion? Don't just read, join in!
Create an account today to enjoy exclusive features and engage with our awesome community!
Sign up| Related Posts | Replies | Views | Activity | |
|---|---|---|---|---|
|
1
Sep 24
|
1558 | ||
|
1
Aug 24
|
346 | ||
|
1
Aug 24
|
394 | ||
|
0
Aug 24
|
252 | ||
|
Search the 'log notes'
Solved
|
|
1
Apr 24
|
2083 |
To clarify, we need to search on any contact associated with the company attached to an opportunity. CRM Search currently returns opportunities if the searched name is on the Opportunity Contact field. There might be several contacts on the company, like a contact for invoicing. Those names are not utilised during search or filter on contact names linked to the opportunity - and we need to do exactly that.