Difference between revisions of "Knowledgebase Search: 3 letter term in search, no results are being returned"
Jump to navigation
Jump to search
(Created page with "In order to allow three character searches in the knowledgebase please carry out the following: Access the Supportworks Server 1..Stop All Services from the services console...") |
|||
Line 12: | Line 12: | ||
4..Restart Only the SwSQLServer | 4..Restart Only the SwSQLServer | ||
+ | |||
5..Run the SupportWorks Interactive SQL Program (Start->Programs->Hornbill Core Services->Interactive SQL) | 5..Run the SupportWorks Interactive SQL Program (Start->Programs->Hornbill Core Services->Interactive SQL) | ||
+ | |||
6..Enter the following SQL | 6..Enter the following SQL | ||
Revision as of 10:41, 10 July 2015
In order to allow three character searches in the knowledgebase please carry out the following:
Access the Supportworks Server
1..Stop All Services from the services console: services.msc
2..Edit the following file C:\Program Files\Hornbill\Core Services\SwSQLServer\Bin\SwSQL.ini (where C: = drive you have installed supportworks server on)
3..Add the following parameter and Save the changes
set-variable = ft_min_word_len=3
4..Restart Only the SwSQLServer
5..Run the SupportWorks Interactive SQL Program (Start->Programs->Hornbill Core Services->Interactive SQL)
6..Enter the following SQL
Use sw_knowledgebase; Alter Table KbDocuments Drop Index Title; ALTER TABLE kbdocuments ADD FULLTEXT (Title,Keywords,Problem,Solution,CallProbCode);
7..Thereafter restart the SwSql server service and all remaining services.