cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
Showing results for 
Search instead for 
Did you mean: 

Custom Stoplist

Custom Stoplist

Due to Integrity using Full Text Indexes, Integrity should have it's own custom stoplist instead of using the system default stoplist. The reason for this is because if the client uses their own custom stoplist and Integrity should ever update the indexes the updated indexes would revert back to the system default stoplist. Integrity should manage it's own custom stoplist so that the stoplist has a uniformed name and the concern of updates/upgrades/patches causing the indexes to revert to system default would no longer be a problem. Below is the suggested name of the stoplist:

 

create fulltext stoplist IntegrityStoplist from system stoplist;

alter fulltext index on Text0 set stoplist = IntegrityStoplist;

alter fulltext index on Text1 set stoplist = IntegrityStoplist;

alter fulltext index on Text3 set stoplist = IntegrityStoplist;

alter fulltext index on Text5 set stoplist = IntegrityStoplist;

alter fulltext index on TRMetadata set stoplist = IntegrityStoplist;