search

mimecorg / webissues

WebIssues team collaboration system.
https://webissues.mimec.org/
GNU Affero General Public License v3.0
59 stars 14 forks source link

[WISH] fulltext search #21

Open xanathon opened 4 years ago

xanathon commented 4 years ago

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 commented 4 years ago

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

nicojmb commented 4 years ago

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

mimecorg commented 4 years ago

You can use multi-select dropdown attributes as tags.

mguinness commented 3 years ago

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 commented 2 years ago

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