View Issue Details
ID | Project | Category | View Status | Date Submitted | Last Update |
---|---|---|---|---|---|
0004843 | mantisbt | filters | public | 2004-11-10 03:15 | 2014-01-13 20:11 |
Reporter | polzin | Assigned To | jreese | ||
Priority | normal | Severity | feature | Reproducibility | N/A |
Status | closed | Resolution | fixed | ||
Fixed in Version | 1.2.0 | ||||
Summary | 0004843: feature request: improving fulltext search | ||||
Description | As full text search is used quite often, I think it would be nice to have a full text search with improved capabilities. As Google is the current standard for search engines, Mantis could mimic the Google syntax. Probably this a difficult task, but I can not believe that this has not been done 100 times somewhere in open-source code that could be reused. I saw that mysql has a "FULLTEXT INDEX" functionality with some other boolean search syntax, but probably this is not sufficient (as we have search in multiple tables)... A similar issue was discussed in 0002921. | ||||
Additional Information | probably everyone knows google´s syntax, but anyway... A B C - search for issue with A and B and C | ||||
Tags | No tags attached. | ||||
has duplicate | 0006192 | closed | thraxisp | In the free search: search for more than one keyword |
has duplicate | 0007854 | closed | Need advanced text search options | |
has duplicate | 0009105 | closed | vboctor | Enhanced free text search |
has duplicate | 0001878 | closed | vboctor | Search capability needs more flexibility. |
has duplicate | 0010782 | closed | dhx | "NOT CONTAIN" filter |
related to | 0005525 | new | Regex-based search filter. |
BTW, the documentation still insists that the bugnotes are not searched. |
|
I am trialing the following change on my Mantis 1.1.1 install to use mysql 5.0's builtin BOOLEAN MODE text search which is very similar to Google's logic operators: http://dev.mysql.com/doc/refman/5.0/en/fulltext-boolean.html Replace the following 2 lines in core/filter.api, approx line 1235:
With:
To resolve this issue we still need:
|
|
Issues with above approach so far:
|
|
It would also be useful to have a config option where we can add customfields to the search. |
|
update to the earlier code. This incorporates the old literal search in as well as the new google-like search. This addresses the two issues identified earlier. |
|
Implementation committed to 1.2.x and master branches. |
|
MantisBT: master-1.2.x ff7f362f 2009-11-30 12:40 Details Diff |
Issue 0004843: Implemented improved text filtering The free text filter box now searches for individual terms in the field separately, obeys quoting patterns, and allows for negation. All terms found are required to be found somewhere in the issue (or not found anywhere for negated terms) in order for the issue to match the filter. Example searches and their expected results: bus car Should find any issue that mentions both "bus" and "car" "micro computer" Should find any issue that mentions "micro computer" exactly; this matches the existing search behaviors apple -banana Should find any issue that mentions "apple" but has no mention of "banana" circuit -"power line" Should find any issue that mentions "circuit" but has no mention of "power line" |
Affected Issues 0004843 |
|
mod - core/filter_api.php | Diff File | ||
MantisBT: master 60a4d24a 2009-11-30 12:40 Details Diff |
Issue 0004843: Implemented improved text filtering The free text filter box now searches for individual terms in the field separately, obeys quoting patterns, and allows for negation. All terms found are required to be found somewhere in the issue (or not found anywhere for negated terms) in order for the issue to match the filter. Example searches and their expected results: bus car Should find any issue that mentions both "bus" and "car" "micro computer" Should find any issue that mentions "micro computer" exactly; this matches the existing search behaviors apple -banana Should find any issue that mentions "apple" but has no mention of "banana" circuit -"power line" Should find any issue that mentions "circuit" but has no mention of "power line" |
Affected Issues 0004843 |
|
mod - core/filter_api.php | Diff File |