[rt-users] Modifying SimpleSearch in RT 3.8.2

[Donovan Young]

As an aside, if the base code needs to be modified... I wonder if we  
could add the ability to use "all:" as a modifier much like the  
"fulltext:" modifier to the search routines? Alas, once again I can't  
seem to find where that is implemented.

On Apr 7, 2009, at 2:05 PM, Kenneth Marshall wrote:

> On Tue, Apr 07, 2009 at 01:55:19PM -0400, Jerrad Pierce wrote:
>> On Tue, Apr 7, 2009 at 13:43, Donovan Young
>> <dyoung-rtusers at techsafari.com> wrote:
>>> We've recently upgraded to 3.8.2 from 3.6.3 and originally the
>>> SimpleSearch feature would search all tickets (active and inactive)
>>
>> Please see the list archives.
>>
>> It really is best to search active tickets only, but you probably  
>> want
>> to add one of
>> the patches to allow you to modify a search to target
>> active/inactive/any tickets.
>>
>> -- 
>> Cambridge Energy Alliance: Save money. Save the planet.
>> _______________________________________________
>> http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users
>>
>
> I will second the comment about searching active tickets only. In  
> particular
> the fulltext:word option will have a (ahem) dramatic affect on the I/ 
> O load
> of your database if you are not using a system that supports full-text
> indexing. Limited to active tickets might me manageable, but all  
> tickets is
> a problem that gets worse and worse as new tickets continue to be  
> added.
> Just how many sequential scans of your database can your backend  
> support? :)
> Currently, Oracle and PostgreSQL support full-text indexing with RT.
>
> My two cents.
> Ken