Question

I have a case which causes the search indexer to choke. Can I have the indexer skip it?

Answer 1

The blacklist for case indexing is set in the Setting table in the database. To add a case number (replace "CaseNumberToBlackList" below) to the blacklist, do the following.

1. Get the current value of the blacklist

   SELECT * FROM Setting WHERE sKey = 'sBugIndexBlacklist';

2. If there are zero rows returned, then:

   INSERT INTO Setting(sKey,sValue) VALUES('sBugIndexBlacklist','CaseNumberToBlackList');

3. If there is one row returned with no value, do this:

   UPDATE Setting SET sValue = 'CaseNumberToBlackList' WHERE sKey = 'sBugIndexBlacklist';

4. If the row comes back with an sValue, grab the string value, and add your case number, and a comma:

   UPDATE Setting SET sValue = 'OldStringValue,CaseNumberToBlackList' WHERE sKey = 'sBugIndexBlacklist';

Related: you can tell FogBugz only to index recent closed and spam cases.