Exclude keywords using the search function

[Gasmann]

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

[Wilson Logan]

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.

[Gasmann]

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

[danb]

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.