SugarCRM Useful Tip – Wild Card Search

Normally, when performing a search for the text you have entered in SugarCRM, the system by default will look for that text at the start of the field. Use the percent symbol (%) at the beginning of your text and SugarCRM will search for that piece of text in the whole field.

Example:
Entering ‘mor’ in the search field would give results such as Morgan, Morris and Mortimer
Entering ‘%mor’ would also include Claymore, Humorous and Immoral in the results.

You can even use the wildcard in between words to search for multiple keywords.
Example:
Entering ‘mike%pass%out’ would allow us to search for the record titled “Mike’s Password for Outlook” without needing to know all the title.

This tip was originally posted on the SugarUK Blogs where you can find a whole host of other useful SugarCRM tips.

2 thoughts on “SugarCRM Useful Tip – Wild Card Search

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