Re: [ic] Return best sellers from a single category?

[Kevin Walsh <suppressed>]

"IC" <suppressed> wrote:
> "IC" <suppressed> 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.
> 
> Just tried that, still no joy, it seems to be the sort order at the end that
> doesn't work, must be something IC doesn't like with the tf or to lines? Any
> other ideas?
> 
Presumably you've tried removing the table name from the "tf"
parameter.  The "tf" parameter only expects column names and optional
sort options:

    http://www.interchange.rtfm.info/icdocs/Search_parameters.html#mv_sort_field_tf

-- 
   _/   _/  _/_/_/_/  _/    _/  _/_/_/  _/    _/
  _/_/_/   _/_/      _/    _/    _/    _/_/  _/   K e v i n   W a l s h
 _/ _/    _/          _/ _/     _/    _/  _/_/    suppressed
_/   _/  _/_/_/_/      _/    _/_/_/  _/    _/

_______________________________________________
interchange-users mailing list
suppressed
http://www.icdevgroup.org/mailman/listinfo/interchange-users