News:

Yahoo Groups closing on Dec 14th 2019

Main Menu

Exclude keywords using the search function

Started by Gasmann, November 12, 2013, 11:39:07 PM

Previous topic - Next topic

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

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.


SMF spam blocked by CleanTalk