Question

You can prevent FogBugz from indexing a particular case or cases by blacklisting it/them. How can I tell FogBugz only to index cases newer than a specific date or case number?

Answer 1

For indexing of closed and spam cases, you can specify a maximum number of months to look back for last-edits. In the setting table, set sValue to the number of months to go back from todays date where sKey = 'cMonthsMaxToIndex'

Don't limit indexing:

DELETE FROM Setting WHERE sKey = 'cMonthsMaxToIndex'
INSERT INTO Setting (sKey, sValue) VALUES ('cMonthsMaxToIndex', '0')

Only index closed and spam cases edited less than 2 months ago:

DELETE FROM Setting WHERE sKey = 'cMonthsMaxToIndex'
INSERT INTO Setting (sKey, sValue) VALUES ('cMonthsMaxToIndex', '2')