Author Topic: Exclude keywords using the search function  (Read 1345 times)

Gasmann

  • Test Team
  • Sr. Member
  • *
  • Posts: 31
Exclude keywords using the search function
« on: November 12, 2013, 04:39:07 PM »
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

  • Administrator
  • Hero Member
  • *****
  • Posts: 2521
    • Email
Re: Exclude keywords using the search function
« Reply #1 on: November 13, 2013, 03:02:44 AM »
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

  • Test Team
  • Sr. Member
  • *
  • Posts: 31
Re: Exclude keywords using the search function
« Reply #2 on: November 14, 2013, 09:42:19 AM »
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

  • Regular Members
  • Sr. Member
  • *
  • Posts: 203
Re: Exclude keywords using the search function
« Reply #3 on: February 17, 2014, 12:33:12 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