Fulltext search with date ranges

RT Users
1

Hi,

I know the caveats with enabling a fulltext search on a non- PostgreSQL
or sphinx setup. However,

Can RT do a fulltext search (/Search/Simple.html) with a date range?

I suspect the answer is no, that this is not a supported field, but
thought I would ask anyway; something like:

fulltext:coffee Created>-2 days ago and Created <= today

I have a portlet that I copied from
http://requesttracker.wikia.com/wiki/Full_Text_Search_Portlet

and see date ranges here for a sphinx search:
http://requesttracker.wikia.com/wiki/IntegrateSphinx

and thought that adding date ranges to Full_Text_Search_Portlet
might make this a little faster.

It is currently fine in testing with about 30,000 tickets;
v. slow for resolved tickets as expected, but fine at the moment
for open/stalled/new tickets.

RT: 4.0.6
MySql: mysql-5.0.95-1.el5_7.1
no sphinx (for another day)

Regards,
Jason Doran
National University of Ireland, Maynooth

2

Can RT do a fulltext search (/Search/Simple.html) with a date range?

I suspect the answer is no, that this is not a supported field, but
thought I would ask anyway; something like:

fulltext:coffee Created>-2 days ago and Created <= today

You can access full text searching through the normal search builder
too, just choose “Content” as your field, matches as the operator, and
“coffee” as the value (which will produce: Content LIKE “coffee”).

FTS is not limited to the simple search.