Skip ke Konten
Menu
Pertanyaan ini telah diberikan tanda
1 Balas
3008 Tampilan

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?



Avatar
Buang
Penulis

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.

Jawaban Terbai

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    


Avatar
Buang
Penulis

This works very well - thank you!

Post Terkait Replies Tampilan Aktivitas
2
Jun 25
1469
1
Sep 24
3484
1
Agu 24
1764
1
Agu 24
1991
0
Agu 24
252