Hello,
being new to version 4.xxx I'd like to exclude keywords when searching a database.
Example: Searching for "Jane" in the subject or message body I want to be able to exclude "Addiction"
to avoid a ton of false positives.
Have I overlooked something?
Thanks
Juergen
Hi Juergen,
Sorry, yes we need to revisit the way search works.
The way I envisage it working is if you want to exclude something you prefix it with -
So to find Bob and not Jane your search would be:
Bob -Jane
Its something we need to work on.
Cheers,
Wilson.
Hello Wilson,
> Sorry, yes we need to revisit the way search works.
> The way I envisage it working is if you want to exclude something you prefix it with -
That would solve my problem. The folks at DIMEADOZEN use "+" and "-". Your suggestion is similar to eBay's extended search.
Thanks!
Juergen
Quote from: Gasmann on November 14, 2013, 04:42:19 PM
Hello Wilson,
> Sorry, yes we need to revisit the way search works.
> The way I envisage it working is if you want to exclude something you prefix it with -
That would solve my problem. The folks at DIMEADOZEN use "+" and "-". Your suggestion is similar to eBay's extended search.
Thanks!
Juergen
Currently the search looks to use just a simple LIKE operation for subject and content searches. The UI would possibly need to be modified to permit selection between "All these words" and "Exact phrase".
But the search probably also be changed over to use SQLITE's FTS search engine.
http://www.sqlite.org/fts3.html
So it is a bit of work and will need to come after the major functionality is complete.