Full text search

Hi,

In RT 3.x, one could do a full text “simple search” by entering
"fulltext:". I tried this in RT 4 but it doesn’t work.

Is there a way to do a full text search in RT 4?

~ Tom

Hi,

In RT 3.x, one could do a full text “simple search” by entering
“fulltext:”. I tried this in RT 4 but it doesn’t work.

Is there a way to do a full text search in RT 4?

That syntax is still supported but by default non-indexed FTS isn’t
enabled. You can either enable it in your config, or, more usefully,
setup RT 4’s indexed FTS support.

Thomas

I have had this configured in my RT 4.0.4 installation as follows:

Set(%FullTextSearch,
Enable => 1,
Indexed => 0,
);

but the results when using fulltext: I don’t get the
expected results. Searching for things that ought to return dozens of hits
return maybe 2 or 3.

I will try to dig into it more but wonder if anyone else has seen this.

DaveOn Thu, Dec 8, 2011 at 1:31 PM, Thomas Sibley trs@bestpractical.com wrote:

On 12/08/2011 01:28 PM, Thomas Smith wrote:

Hi,

In RT 3.x, one could do a full text “simple search” by entering
“fulltext:”. I tried this in RT 4 but it doesn’t work.

Is there a way to do a full text search in RT 4?

That syntax is still supported but by default non-indexed FTS isn’t
enabled. You can either enable it in your config, or, more usefully,
setup RT 4’s indexed FTS support.

What's New in 4: Fast full-text searching — Best Practical Solutions

Thomas

RT Training Sessions (http://bestpractical.com/services/training.html)

  • Boston March 5 & 6, 2012

This is the same configuration I have in my 4.0.2 installation. Seems like to get full benefits from it I needed to restart MySQL and of course Apache. Maybe this will help. I’ve hardcoded the fulltext: directive into the simple search, and it works beautifully for us here.From: rt-users-bounces@lists.bestpractical.com [mailto:rt-users-bounces@lists.bestpractical.com] On Behalf Of Dave Pascoe
Sent: Thursday, December 08, 2011 3:36 PM
To: rt-users@lists.bestpractical.com
Subject: Re: [rt-users] Full text search

I have had this configured in my RT 4.0.4 installation as follows:

Set(%FullTextSearch,
Enable => 1,
Indexed => 0,
);

but the results when using fulltext: I don’t get the expected results. Searching for things that ought to return dozens of hits return maybe 2 or 3.

I will try to dig into it more but wonder if anyone else has seen this.

Dave

I have had this configured in my RT 4.0.4 installation as follows:

Set(%FullTextSearch,
Enable => 1,
Indexed => 0,
);

but the results when using fulltext: I don’t get the
expected results. Searching for things that ought to return dozens of
hits return maybe 2 or 3.

If your search string has spaces in it, are you quoting ?
Paste a real example so we can see.

Thomas

I have had this configured in my RT 4.0.4 installation as follows:

Set(%FullTextSearch,
Enable => 1,
Indexed => 0,
);

but the results when using fulltext: I don’t get the
expected results. Searching for things that ought to return dozens of
hits return maybe 2 or 3.

You can also look at the TicketSQL generated by clicking on the Advanced
tab after running your simple search.

Thomas

My bad. I wasn’t expecting that Status=resolved tickets were not going to
be searched. Operator error. I also learned that you can pass status into
SimpleSearch right from the search box. Solves my needs.

Thanks for the responses.

My bad. I wasn’t expecting that Status=resolved tickets were not going
to be searched. Operator error. I also learned that you can pass
status into SimpleSearch right from the search box. Solves my needs.

We just merged some commits to 4.0-trunk that improve the simple search
documentation at /Search/Simple.html. You’ll see it in the 4.0.5 release.

Thomas