Datafeedr Support Forums

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)

ayorofrance January 16th, 2011 10:45 AM

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!

Eric January 16th, 2011 11:39 AM

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

ayorofrance January 16th, 2011 11:54 AM

Amazing!

Thanks for solving my problem!!!


All times are GMT -5. The time now is 05:49 PM.

Powered by vBulletin® Version 3.6.8
Copyright ©2000 - 2021, Jelsoft Enterprises Ltd.