[rt-users] Help! I enabled Full Text search and now Simple search won't look at Subjects !!

[Alex Vandiver]

On Fri, 19 Aug 2016 16:35:07 +0200
Claes Merin <claes at gastabud.com> wrote:
> We are using sphinx (since last night) for FTS searches.
> 
> Setup is as described in this excellent guide:
> 
> http://blog.christosoft.de/2016/07/rt4-request-tracker4-fulltext-search-sphinx-debian-jessie/

Is there a reason you're not using MySQL's built-in search, available
since 4.2.10?  It's more performant, and has none of the caveats:
https://docs.bestpractical.com/rt/4.2/full_text_indexing.html#Caveats1

Especially since it allows for incremental indexing of new attachment
rows, I know of no reason to prefer Sphinx.

> We also ran in to the problem described here, and I was thinking if one
> could resolve it by including the subject in the sphinx database...

I expect that should work fine.

> Modifying the query in the guide to simply include the t.Subject like
> this...
> 
> ## /etc/sphinxsearch/sphinx.conf
> sql_query = \
>   SELECT a.id id, t.Subject, a.content FROM Attachments a \
>   JOIN Transactions txn ON a.TransactionId = txn.id AND txn.ObjectType =
> 'RT::Ticket' \
>   JOIN Tickets t ON txn.ObjectId = t.id \
>   WHERE a.ContentType LIKE '%text%' AND t.Status != 'deleted'
> ##
> 
> The problem with this is, if there is a ticket that does not have an
> attachment, it will not get indexed and is not searchable through FTS...

The "attachments" table is used to index all content in RT.  This
includes textual content, such as the bodies of messages.  As such, it
is impossible for a ticket to not have at least one Attachment record.

 - Alex