Wednesday 5 December 2012

MSCRM 2011: Making Fields Searchable in an Entity

A Client recently asked, “How do I search by a custom field in an entity and have records returned in the view?” Not all fields in CRM are searchable by default. To make a field searchable you need to add it as a 'find column' to the entity's Quick Find View.

Let’s go through an example of this. Suppose there is a custom field on the Contact entity to designate the Parent Account for the Contact. We’d like to be able to search on that Parent Accoun field to find all those Contacts where a particular representative appears.

When you enter that value into the Contact search box and press enter I get the message that nothing is found. Why?

The reason that nothing is found is that the Parent Accoun field is not searchable by default. To make it searchable go to the Customize Entity option on the navigation ribbon. This will launch the customization screen where you can then choose the 'Views' option under the Contact entity.

Open the view whose type is 'Quick Find View' and select the 'Add Find Columns' option.

Put a check mark next to the Parent Account field so you can now search on it.

Add the field to the Quick Find View also by choosing ‘Add View Columns’ option and put a check mark next to the Account Representative field.

Publish your Customizations. You can now search on that field.

No comments:

Post a Comment