[rt-users] Allowing fulltext queries to search closed tickets

Rich McDonough rich.mcdonough at worldgaming.com
Mon Nov 3 14:53:53 EST 2008

I'm fairly new to RT so please forgive me if this is a terribly  
obvious question. Our RT installation is only showing results for full  
text searches from open, new and stalled tickets, but we would like  
this to change to searching our entire ticket history by default.  
Here's the actual SQL statement that our database logs:

LOG:  statement: SELECT COUNT(DISTINCT main.id) FROM Tickets main JOIN  
Transactions Transactions_1  ON ( Transactions_1.ObjectId = main.id )  
JOIN Attachments Attachments_2  ON ( Attachments_2.TransactionId =  
Transactions_1.id )  WHERE (Transactions_1.ObjectType = 'RT::Ticket')  
AND (main.Status != 'deleted') AND ( (  ( Attachments_2.Content ILIKE  
'%test%' )  )  AND  ( main.Status = 'new' OR main.Status = 'open' OR  
main.Status = 'stalled' ) ) AND (main.Type = 'ticket') AND  
(main.EffectiveId = main.id)

I have to assume that this is not too difficult to achieve, but I have  
yet to dig up where this query is being generated from. We're running  
version 3.8.1 on Postgres 8.3.4.

Thanks for any assistance that anyone can offer! Thus far I've been  
very impressed with RT.

Rich McDonough
System Adminstrator
rich.mcdonough at worldgaming.com

More information about the rt-users mailing list