On-Demand (V1 Hosted) Installations
Systems hosted by Digital.ai all use the default SQL Stop Word lists.
The Agility Full-Text Search (FTS) also uses a Stop Word list to prevent the search index from being overcrowded by overly common terms. FTS indexes stop words so any queries that require a stop word will not show any results.
Because the Stop Words list includes single character terms, be sure to exclude single character terms from your search query. This includes any standalone letters or numbers.
Below are samples of search queries that return no results. In each case, the stop word is highlighted.
|Query||Reason for No Results|
|Sprint 1||single-character term|
|A Book||single-character term|
|Page 18 of 42||
|1.2.3 ABC||three single-character terms - treated as 1 AND 2 AND 3 AND ABC|
The content in this article applies to On-premise Agility instances only. If you are an On-Demand (Agility Hosted) customer, see On-Demand (Agility Hosted) System Maintenance.
On-Premise (Local) Installations
If Agility is installed on your local machines, you can alter the Stop Words List to suit your needs. Refer to your SQL Server documentation for instructions on altering the Stop Word List on your SQL Server version. For more information, please see http://msdn.microsoft.com/en-us/library/ms142551.aspx.
Stop Words List Samples
As a reference, below are the contents of the English Stop Wordlist for SQL 2005. Note that Stop Word lists are language-specific.
1 2 3 4 5 6 7 8 9 0
Please sign in to leave a comment.