Commerce Server General - Searching multiple categories

This is Interesting: Free IT Magazines  
Home > Archive > Commerce Server General > May 2007 > Searching multiple categories





You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

Author Searching multiple categories
Eric

2007-05-25, 7:15 pm

Hi,

I have a product catalog that consists of a lot of categories. One
product can be a member of multiple categories, for example both
"Sporting jackets" and "Sizes Small - Medium" or something like that.

Since the products are sorted this way, my searches in the catalog
need to be in the form of "Give me all products that are in category
'Sporting jackets' AND category 'Size small' with search criterias X".

I have previously done this with pure SQL calls, but I would like to
use the CatalogSearch for this. However, I seems to only be able to
specify one category of products to search in with the CatalogSearch
object. How do I go about making searches in multiple categories at
once?

Kind Regards,
Eric

Eric

2007-05-29, 1:19 pm

On 25 Maj, 11:43, Eric <s...@rallymedia.nu> wrote:
> Hi,
>
> I have a product catalog that consists of a lot of categories. One
> product can be a member of multiple categories, for example both
> "Sporting jackets" and "Sizes Small - Medium" or something like that.
>
> Since the products are sorted this way, my searches in the catalog
> need to be in the form of "Give me all products that are in category
> 'Sporting jackets' AND category 'Size small' with search criterias X".
>
> I have previously done this with pure SQL calls, but I would like to
> use the CatalogSearch for this. However, I seems to only be able to
> specify one category of products to search in with the CatalogSearch
> object. How do I go about making searches in multiple categories at
> once?
>
> Kind Regards,
> Eric



I found out that this is one of the New Cool Features(tm) of CS2007
(I'm running 2002). However, I made a temporary solution where a new
category is added, and the categories I wish to search are placed as
sub-categoris to that one. Hence a recursive search searches both my
categories. Problem avoided until the 2007 upgrade


Sponsored Links






Free braindumps | Software forum | Database administration forum

Copyright 2003 - 2008 webservertalk.com