Hi all,
I have been working on integrating the Sphinx full-text search engine in our RT.
I have everything in place regarding Sphinx.
I have written a new portlet that can be installed in the “RT at a glance” page. The portlet lets us search for text and filter the results for requestor, queue, date range. The form submits all search parameters to a PHP page that uses the Sphinx API to perform the actual search. Performance is outstanding!
Presently we are returning results in a rather crude html table. What I would like to do is somehow passing results to RT and using the standard Results.html page to display them (hence gaining all the standard RT features like pagination and graphs).
Is it possible at all? Could someone help me implement it?
If this is not possible I will at least use RT’s CSS to try to make it look integrated.
Whatever I’ll come up with, I am willing to publish everything on the RT wiki so that others can benefit from lightning-fast full-text searches.
I have been working on integrating the Sphinx full-text search engine in our RT.
I have everything in place regarding Sphinx.
I have written a new portlet that can be installed in the “RT at a glance” page. The portlet
lets us search for text and filter the results for requestor, queue, date range. The form
submits all search parameters to a PHP page that uses the Sphinx API to perform the actual
search. Performance is outstanding!
Presently we are returning results in a rather crude html table. What I would like to do is
somehow passing results to RT and using the standard Results.html page to display them (hence
gaining all the standard RT features like pagination and graphs).
To use CollectionList (which is the basis of Results.html) you really
need to get at an RT::Tickets object, or just build a TicketSQL query
from your PHP scrips that passes back in to RT (perhaps just a
collection of ticket ids)
As Kevin suggested you can get IDs out of results and build “id in (…)”
query using RT API.
If you install sphinx search engine for mysql then you can use sphinx in any
search not only in custom portlet. Similar change is in 3.999 branch in the
repository.
I have been working on integrating the Sphinx full-text search engine in our
RT.
I have everything in place regarding Sphinx.
I have written a new portlet that can be installed in the “RT at a glance”
page. The portlet lets us search for text and filter the results for
requestor, queue, date range. The form submits all search parameters to a
PHP page that uses the Sphinx API to perform the actual search. Performance
is outstanding!
Presently we are returning results in a rather crude html table. What I
would like to do is somehow passing results to RT and using the standard
Results.html page to display them (hence gaining all the standard RT
features like pagination and graphs).
Is it possible at all? Could someone help me implement it?
If this is not possible I will at least use RT’s CSS to try to make it look
integrated.
Whatever I’ll come up with, I am willing to publish everything on the RT
wiki so that others can benefit from lightning-fast full-text searches.
If you install sphinx search engine for mysql then you can use sphinx in any
search not only in custom portlet. Similar change is in 3.999 branch in the
repository.
Could you elaborate on this? I’ve not used sphinx, though fast fulltext
searching sounds fantastic and I see sphinx can “speak” the mysql api.
How would we plug RT into sphinx for searches? What’s the change in the
3.999 branch you mention?
Paul,
I have finished the work on integrating Sphinx with RT. I am publishing all I did in the RT Wiki; look for “IntegrateSphinx” if you want to see the info on the wiki.
For now I did not use the suggestions from Kevin and Ruslan… we did a hack to integrate search results in RT, but it is working wuite well in our environment.
I plan to improve our code though, and I can foresee “real” and complete RT integration in the future with the help of the community.
Ruslan, I am interested in what you said about the 3.999 branch too, because I’m not willing to do duplicate work.
If you install sphinx search engine for mysql then you can use sphinx in any
search not only in custom portlet. Similar change is in 3.999 branch in the
repository.
Could you elaborate on this? I’ve not used sphinx, though fast fulltext
searching sounds fantastic and I see sphinx can “speak” the mysql api.
How would we plug RT into sphinx for searches? What’s the change in the
3.999 branch you mention?