­
+1 (408) 320-0380

Mini guide to Related Record Search

The ability to access the needed data quickly cannot be overestimated in today’s fast-paced and ever-changing business environment. However, with an enormous database of records, it can be quite challenging to find a specific piece of information about the account related to the contact or the email that was sent to this very contact a month ago. EspoCRM provides you with the ability to search and filter records on the relationship and side panels.
To illustrate how the related record search feature works, let’s assume that we’d like to see all the opportunities that are related to certain contact and were created last year. In order to do that, we’ll navigate to contacts and choose a specific one (let it be Rachel Bisier).

Open Contact in EspoCRM

At left side and at the bottom of the page you can find relationship panels and side panels (activities, history etc.). To search for a specific record on these panels (in our case we choose Opportunities panel), click the drop-down menu button in the top right corner of the panel and select View List option.

All Contact Relations

View Contact Relations
As you can see in the next window, we are able to see the list of opportunity records related to our contact. We can search records either by entering the needed word or text and pressing the search button or by specifying the search filters. In this case, we are going to specify the search filter as we want to see the Opportunity records that were created last year. That’s why we press Settings Button button and select Created at search filter.

Choose Search Field

Then we select Last year option from the list, click Search button and enjoy the results.

Set Filter Value

As a rule, the side panel drop-down menu has a separate for View List options for emails, meetings and calls, but the procedure of related record search on this panels is practically the same as described above.

View Contact Related Events

You are also able to specify the fields which user will use for filtering search at Administration > Layout Manager > Specific entity type > Search Filters.

Edit Search Layout

Hope the information was useful for you! Thanks for paying attention!

Cookies & Privacy Policy

Our website uses cookies to give you the best user experience on our website and to help us deliver our services. By using our services, you agree to our use of cookies. Click here for more information.
Necessary
Strictly necessary cookies help make a website navigable by activating basic functions such as page navigation and access to secure website areas. Without these cookies, the website would not be able to work properly.
Statistical
Statistical cookies help the website owner understand how visitors interact with the website by collecting and reporting information.
Marketing
Marketing cookies are used to track visitors across websites. The intention is to display ads that are relevant and interesting to the individual user and thus more valuable for publishers and third-party advertisers.
Accept AllCustomizeAccept Necessary