Full text search tricks

sugarcrmdevelopers —  July 6, 2012 — 6 Comments

Editor’s Note: Earlier this week we did a blog post around the new FTS engine introduced in Sugar 6.5 Pro and above, talking about how to get it all setup and running. Today, Sugar Engineer Jimmy Chen details a few tips and examples to best use the tool to enable easier searching.

Here are some tricks and examples that may help users using the full text search that is new to Sugar 6.5 Pro and above.

Type ahead: When full text search is enabled. The search box has autocomplete turned on to support typeahead. When you enter 3+ characters, the search begins and shows matches in a box.

Wildcard match: When you enter 3+ characters to search without hitting the enter or return key, or without clicking on the search button. Sugar automatically adds a wildcard to your search string. For example, when you type in pacific, both pacific and pacifica will be returned.

Exact match: When you hit enter or return key, or when you click on the search button, then no wildcard is appended to the search string. For example, if you enter pacific followed by an enter key, only pacific, and not pacifica, will be returned.

AND: When you enter multiple words to search, search engine uses OR operator by default. For example, if you enter “abc xyz” (w/o quotes), all documents that contain either abc or xyz or both, will be returned. If you only want to search for the documents that contain both abc and xyz, you can use “abc AND xyz” (w/o quotes). AND needs to be uppercase. That will give you “abc def xyz”, or “xyz abc”, but not “abc” or “xyz”.

Double quotes: When you enter multiple words to search, you can use double quotes to search them as a term. For example, enter “abc xyz” (with quotes) will return only “abc xyz”, but not “xyz abc”, “abc” or “xyz”.

6 responses to Full text search tricks


    Is it really too much to ask that it is made clear which version of Sugar the article applies.We know that sugar adds very little to Sugar CE so I guess by default we assume its only for Pro/Ent/Ult


    How can I disable this completely? We host a dev site for an on-demand client and the fatal log is being filled up with these errors every minute:

    Fri Jan 11 17:17:02 2013 [7467][1][FATAL] FTS Server is down?

    Fri Jan 11 17:17:02 2013 [7467][1][FATAL] FTS Server is down, postponing the job.


      Are you wanting to turn off logging or turn off FTS? Not sure if you can disable FTS.

      It may be better to get support involved to figure out why these errors keep popping up. Let me know if you’d like my help there.


    Using 6.5.11 Pro, can I use wildcard character “%” at the beginning?

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