Use * as a wild card in searches

(1) Share

Report

Posted on by Community Member

When performing a search in Microsoft Dynamics CRM 2013, can we use the * symbol as a wild card. For example if I search for “Coca*” will the result return both “Coca Cola” and “Coca-Cola”?

Use * as a wild card in searches

*This post is locked for comments

I have the same question (0)

All responses (6)

Answers (2)

Verified answer

Mahadeo Matre 17,021 on at

Like (1)

Report
Copy link

Link copied!

Yes..if you search coca* then crm will return all records starting with coca.. depending on quick find column..

When you search fro *coca* then crm will give records whoes contains coca..

Hope this will help..

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report
Copy link

Link copied!

Thanks a lot

Was this reply helpful? Yes No
Verified answer

Mahadeo Matre 17,021 on at

Like (1)

Report
Copy link

Link copied!

Bansri..

here is one good article on wild character search

community.dynamics.com/.../quick-tip-get-wild-with-your-searches.aspx

Was this reply helpful? Yes No
Suggested answer

Mithilesh Kumar 10,047 on at

Like (1)

Report
Copy link

Link copied!

Hi Bansri,

Wild card search happens only for the Text Field.

You cannot wild search for example number field. If you have any Account which has Number of Employee field. You cannot search them.

For that you need to have a hidden Text Field which stores the value of number field and then it is displayed as one of the column in Quick Find view to perform your wild card search.

Thanks

Hope that helps

Was this reply helpful? Yes No
Aileen Gusni 44,524 on at

Like (0)

Report
Copy link

Link copied!

Bansri,

Another limitation is you cannot find the keyword thatn contain the wildcard symbol itself, (* - asteriks)

community.dynamics.com/.../143077.aspx

Another complete explanation you can see this link:

crmtipoftheday.com/.../do-you-know-what-wildcard-is

Thank you.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report
Copy link

Link copied!

You can simply search for "Coca" - CRM assumes you want a wildcard at the end, using a "begins with" type of search.

You only need to use a wildcard if you want to search for unknown characters at the beginning or middle. Eg "*Cola" will return "Coca-Cola" and "Rola-Cola". "*ca*la" will return only "Coca-Cola"

Note this is also case-insensitive, by default (I'm fairly sure this depends on SQL collation settings)

Was this reply helpful? Yes No