[WISH] fulltext search

[xanathon]

From experience it is nesseccary to have a fulltext search option that does not only search for a term in the ticket title, but also in the ticket body.

If this is possible I found no way to do it?

[mimecorg]

Currently it's not possible. Unfortunately, implementing a decent full text search is not trivial.

[nicojmb]

an idea is add possibility to add tags in any issue and can filter in search?

[mimecorg]

You can use multi-select dropdown attributes as tags.

[mguinness]

Unfortunately, implementing a decent full text search is not trivial.

Full text indexes are available on most RDBMS including MySQL, PostgreSQL and SQL Server.

To create an index (on MySQL) use:

ALTER TABLE issue_descriptions ADD FULLTEXT (descr_text);

To search for text (on MySQL) use the following syntax:

SELECT * FROM issue_descriptions WHERE MATCH (descr_text) AGAINST ('timeout');

For advanced searches you can use boolean mode in MySQL but that could be added at a later date.

It's not something I need right now as I've just started using the application (which is awesome btw), but I could see the benefit to search issue descriptions. I don't know PHP, but I'd be happy to help if you have any questions on the database side.

[xabikip]

I started using webissues and is awesome, but it would be nice implement a search capability on description field.