Datafeedr Support Forums - Query Filter excluding keyword

Datafeedr Support Forums (http://www.datafeedr.com/forums/index.php)

- Questions (http://www.datafeedr.com/forums/forumdisplay.php?f=67)

- - Query Filter excluding keyword (http://www.datafeedr.com/forums/showthread.php?t=3677)

Query Filter excluding keyword

Just playing with the new filters... awesome!

My products have the text "Women" in the description if the products are for women (surprise), but there is not way to filter on "Men".

Is it possible to create a query filter on products that do NOT contain the word "Women"?

Sort of like this (although it doesn't work):

Code:

      <li><a href="[server.url type='fullpage' query='word=women']">Women's Glasses</a></li>

      <li><a href="[server.url type='fullpage' query='word=-women']">Men's Glasses</a></li>

Thanks!

The main issue is your MySQL settings. I'm guessing that your MySQL is configured to index words with 4 or more characters. That's why you can't filter on the word "men". I see on your site references to "Men's", but MySQL doesn't treat that as a 4 letter word.

So, you could update your MySQL settings to index words with 3 or more characters (might have to ask your host about that).

For negative searches...

Quote:

The - operator acts only to exclude rows that are otherwise matched by other search terms. Thus, a boolean-mode search that contains only terms preceded by - returns an empty result. It does not return “all rows except those containing any of the excluded terms.” ~ http://dev.mysql.com/doc/refman/5.1/en/fulltext-boolean.html

So, you could try something like this:

Code:

word=sunglasses+-women+-unisex

I just put that into your site and it seemed to return only men's sunglasses.

Eric

Amazing!

Thanks for solving my problem!!!