Microsoft Dynamics CRM

{ZERO CODE DEVELOPMENT} QUICK FIND WILD CARD SEARCH ON WHOLE NUMBER FIELD IN DYNAMICS CRM 2015

Scenario: Be able to do a quick find wild card search using out of box CRM quick find box on whole number field.

Ideal Solution: You must be wondering that it is as simple as configuring a Add Quick Find column in quick find and it will be working.

Reality: Even when we configure Quick find view for whole number fields, it only enables full number matches, not partial matches. For eg, if I want to search on number of employees in out of box account entity, I can only do full matches like 1000, I will not be able to get a result on 100*

ZERO CODE DEVELOPMENT SOLUTION:

I think the scenario is already clear by now.

So, since the example is referring to Dynamics CRM 2015, let us have a practical example on Calculated Fields.

Wait a minute, how are Calculated fields going to be useful here?

clip_image001

Well, we will need to store a hidden calculated field for our whole number field , which will be used in Quick find search.

clip_image002

Step 1: Please create a hidden Calculated Field like this:

image

Step 2: Click Edit and configure like below:

clip_image006

Step 3:

Configure this field in Account Quick find view (Remember in Step 1 field is marked as searchable as well):

clip_image008

Step 4: Publish all customizations.

What about mapping historical data to the new field. Well, calculated fields do not need that.

So, the final test!

clip_image010

Hope it helps!

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s