CRM Dynamics Search wildCard

Question

Hi there

I'm exploring Dynamics CRM 4 and when I search a record for example, a contact, ex. Abcd, Dynamics is searching by Abcd*, including, by default, the WildCard in the end.

Is there any way to also include the Wild Card, by default, in the beggining? Ex. Abcd --> *Abcd*

Answer 1

Sorry, there is no way to do that. CRM is translating the Search query in a SQL Like at runtime, so, there is even no hack (like modifying a stored procedure).

I've done a custom search by integrating an IFrame in a custom ASPX page to avoid using the default "search engine"... maybe this is an alternate solution to your problem.

Answer 2

You should be able to build a pre-plugin for the RetrieveMultiple event and access the Query property of the Input Parameters collection, which will contain the search string that the user typed in. Since you are in the pre event, you can prepend an asterisk to the search string, which should produce your desired results.