Datafeedr Support Forums  

Go Back   Datafeedr Support Forums > Current Version (V3) Forum > Questions
Home Register FAQ Members List Calendar Search Today's Posts Mark Forums Read

Important - The support forums are now in "read-only" mode as we transition to an alternative help desk solution. Feel free to contact us here with any of your questions or search the forums for an existing solution.
 
 
Thread Tools Search this Thread Display Modes
  #1  
Old January 16th, 2011, 10:45 AM
ayorofrance ayorofrance is offline
 
Join Date: Sep 2010
Posts: 430
Default 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!
__________________
WordPress Security - Is your WordPress secure? Get our FREE checklist and find out.

Easy-Email - Access ALL your email accounts with one login & synchronize automatically on all your computers.
  #2  
Old January 16th, 2011, 11:39 AM
Eric's Avatar
Eric Eric is offline
Datafeedr Team
 
Join Date: Feb 2008
Posts: 16,902
Default

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
  #3  
Old January 16th, 2011, 11:54 AM
ayorofrance ayorofrance is offline
 
Join Date: Sep 2010
Posts: 430
Default

Amazing!

Thanks for solving my problem!!!
__________________
WordPress Security - Is your WordPress secure? Get our FREE checklist and find out.

Easy-Email - Access ALL your email accounts with one login & synchronize automatically on all your computers.
 


Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Forum Jump


All times are GMT -5. The time now is 11:48 AM.


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