[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