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?
Well, we will need to store a hidden calculated field for our whole number field , which will be used in Quick find search.
Step 1: Please create a hidden Calculated Field like this:
Step 2: Click Edit and configure like below:
Configure this field in Account Quick find view (Remember in Step 1 field is marked as searchable as well):
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!
Hope it helps!