[ic] Return best sellers from a single category?

[Kevin Walsh]

"IC" <ic at tvcables.co.uk> wrote:
> I am trying to modify the best component loop search to return only the best
> selling products from a single category, I tried adding the following to the
> loop search:-
> 
>        	fi=products
> 		st=db
> 		co=yes
> 		sf=category
> 		se=my category name
> 
> So the whole loop search ended up like this:-
> 
> [loop search="
> 		fi=products
> 		st=db
> 		co=yes
> 		sf=category
> 		se=my category name
> 		fi=merchandising
> 		st=db
> 		ra=yes
> 		tf=times_ordered
> 		to=rn
> 		ml=[control matches 3]
> 	"]
> 
> This doesn't work though, I have tried co=yes and co=no, can anyone suggest
> a way to fix it please?
> 
The "sf" parameter should include the table name, for a joined search,
like "tablename:colname".

See the examples in the documentation, here:

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

Also the mv_search_field (sf) documentation, here:

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

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