Content Manager Search

Searching using the Tittle Word search for “SF Req # 41481” does not return any result where as searching for “41481” returns search results

Run the following query in SSMS to enable noise word from SQL server to get the result:

sp_configure 'show advanced options', 1;

RECONFIGURE;

GO

sp_configure 'transform noise words', 1;

RECONFIGURE;

GO

Searching with question mark (?) Wildcard is not working with an En (–) dash

To get the required result append an asterisk (*) at the end of the word like "organi?ation*".

Group words as phrase option is not available in Content Manager Web Client for notes and any word searches

Alternatively using a double quote "" for Anyword & Title Word search would function as the same.

Searching for an address that includes numbers and text, using the Title Word Search, did not give proper result set or records

In the earlier versions of Content Manager, the SQL server full-text indexing uses the English language by default. In the English language, the Microsoft SQL server will consider the "BOB" word as a currency and whenever there is a number before BOB like "20 Bob Content" the full-text indexing in the Microsoft SQL server will break the words "20 Bob" as one word and "content" as another word. So whenever we search for bob word the SQL server is not able to get that word. A new option, Word breaker language, is introduced in Content Manager 10.1 Patch1 onwards where you can set the word breaker language. By default it is set to Neutral. The available languages are Dutch, English, French, and German.

Records with titles containing the word 16555 PHP do not show up in the searched results

The Term "PHP" is a currency keyword.

Due to this, while querying for the record using title word search, the whole string will be considered as a currency value by the Microsoft SQL database, hence no result will be shown.

Use the title record search as "16555 PHP" and then the results will be shown.

NOTE: The currency keywords are not handled by Microsoft SQL DB, where the search strings will be considered as a currency value due to which there will be no result. We have to enclose the search string containing the currency value within double quotes.

For example, if the search string is 16555 PHP, where PHP is a currency keyword. To get the results, search string should be passed within double quotes as "16555 PHP".