Custom Stoplist

[jarnett]

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;

[olivierlp]

Hello,

We are archiving your idea as part of a general review. This action is based on the age of your idea and the total number of votes received, as per this announcement.

You can always post a new idea with all the details required in the form.

Thank you for your participation.