Hi, playing around with the ticket content search I discovered many "false positive" results.
The _TransContentLimit [1] fetches all transaction, notably also the EmailRecord and CommentEmailRecord transactions which let the content search also found matches for stings which are inserted by templates into outgoing emails. This isn't what I would expect. If I search for content I would expect matches for the content of Create, Comment, Correspond, Forward Ticket and Forward Transaction (the content of an incoming email or the content of an RT user input). Example (vanilla RT 4.2.11 with unindexed search [2] enabled): * create a ticket with subject foo and content bar * search for: Content LIKE 'Greetings' I wouldn't expect a result here. But the 'Greetings' matches the one from default 'HTML Autoresponse template' template [3]. Chris [1] https://github.com/bestpractical/rt/blob/stable/lib/RT/Tickets.pm#L828-997 [2] https://bestpractical.com/docs/rt/4.2/full_text_indexing.html#UNINDEXED-SEARCH [3] https://github.com/bestpractical/rt/blob/stable/etc/initialdata#L260-285