Difference between revisions of "Knowledgebase Search: 3 letter term in search, no results are being returned"

Revision as of 15:46, 20 July 2015

In order to allow three character searches in the knowledgebase please carry out the following:

Access the Supportworks Server

Stop the following services via the services console: services.msc
Edit the following file (where <installPath:> = drive and path of the Supportworks server installation):
<installPath>Core Services\SwSQLServer\Bin\SwSQL.ini
Add the following parameter and Save the changes
```
set-variable = ft_min_word_len=3
```
Restart Only the SwSQLServer
Run the SupportWorks Interactive SQL Program (Start->Programs->Hornbill Core Services->Interactive SQL)

Enter the following SQL

Use sw_knowledgebase;Alter Table KbDocuments Drop Index Title;ALTER TABLE kbdocuments ADD FULLTEXT (Title,Keywords,Problem,Solution,CallProbCode);

@@ Line 3: / Line 3: @@
 Access the Supportworks Server
-..Stop All Services from the services console: services.msc
+# Stop the following services via the services console: services.msc
+# Edit the following file (where <installPath:> = drive and path of the Supportworks server installation):
-..Edit the following file C:\Program Files\Hornbill\Core Services\SwSQLServer\Bin\SwSQL.ini (where C: = drive you have installed supportworks server on)
+#:<installPath>Core Services\SwSQLServer\Bin\SwSQL.ini
+# Add the following parameter and Save the changes
-..Add the following parameter and Save the changes
+#:<pre>set-variable = ft_min_word_len=3</pre>
+# Restart Only the SwSQLServer
- set-variable = ft_min_word_len=3
+# Run the SupportWorks Interactive SQL Program (Start->Programs->Hornbill Core Services->Interactive SQL)
+# Enter the following SQL
-..Restart Only the SwSQLServer
+#:<pre>Use sw_knowledgebase;Alter Table KbDocuments Drop Index Title;ALTER TABLE kbdocuments ADD FULLTEXT (Title,Keywords,Problem,Solution,CallProbCode);
+# Thereafter restart the SwSql server service and all remaining services.
-..Run the SupportWorks Interactive SQL Program (Start->Programs->Hornbill Core Services->Interactive SQL)
-..Enter the following SQL
- Use sw_knowledgebase;
- Alter Table KbDocuments Drop Index Title;
- ALTER TABLE kbdocuments ADD FULLTEXT (Title,Keywords,Problem,Solution,CallProbCode);
-..Thereafter restart the SwSql server service and all remaining services.