[ic] Return best sellers from a single category?

Kevin Walsh kevin at cursor.biz
Sat Apr 19 17:05:08 UTC 2008


"IC" <ic at tvcables.co.uk> wrote:
> Thanks for the reply, I have modified the search to this:-
>
> [loop search="
>                 co=yes
>                 sf=category
>                 se=my category name
>                 nu=0
>                 op=eq
> 
>                 sf=merchandising:times_ordered
>                 se=1
>                 op=ge
>                 nu=1
> 
>                 tf=merchandising:times_ordered
>                 to=rn
>                 ml=[control matches 3]
>         "]
> 
> 
> This returns 3 products from the correct category however it does not return
> the 3 best sellers according to the times_ordered field, is there something
> else missing?
>
"op=ge" is not appropriate for numeric columns (nu=1).
Try "op=>=" instead.

You will find an operator list in the documentation, here:

    http://www.interchange.rtfm.info/icdocs/Interchange_search_engine.html#Coordinated_and_joined_searches

-- 
   _/   _/  _/_/_/_/  _/    _/  _/_/_/  _/    _/
  _/_/_/   _/_/      _/    _/    _/    _/_/  _/   K e v i n   W a l s h
 _/ _/    _/          _/ _/     _/    _/  _/_/    kevin at cursor.biz
_/   _/  _/_/_/_/      _/    _/_/_/  _/    _/



More information about the interchange-users mailing list