|
Home > Archive > Commerce Server Catalog > August 2005 > Searching a Virtual Catalog - Categories Not Returned
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 a Virtual Catalog - Categories Not Returned
|
|
| Colin Bowern 2005-08-29, 5:57 pm |
| I'm trying to execute a search on a virtual catalog and I'm having problems
with it returning the category name. It seems the resulting data set
populates the primaryparentcategory but doesn't populate the categoryname,
origcategoryname, or #categorydisplayname columns in the resulting data set.
CatalogSearch SearchObject = new
CatalogSearch(CatalogObject.CatalogContext);
SearchObject.CatalogNames = "CAD";
SearchObject.SqlWhereClause = "[Origcategoryname] = N'Some Category''";
SearchObject.SearchOptions = new CatalogSearchOptions();
SearchObject.SearchOptions.ClassTypes = CatalogClassTypes.ProductClass |
CatalogClassTypes.ProductFamilyClass;
DataSet Results = SearchObject.Search();
Ideally I would like to get the above to work but those fields I need are
missing. I have searched support.microsoft.com and I don't see any sort of
fixes among the myriad of catalog SQL updates. Has anyone else been able to
populate these fields in a search?
Thanks!
Colin
| |
| Colin Bowern 2005-08-29, 5:57 pm |
| I've determined that those columns may only be valid when returning actual
category records in the result set. Has anyone been able to, outside of
primary parent category, search the virtual catalog based on the original
category name the item resides in?
Thanks,
Colin
"Colin Bowern" <colin.bowern@nospam.officialcommunity.com> wrote in message
news:ekra6OOrFHA.3604@tk2msftngp13.phx.gbl...
> I'm trying to execute a search on a virtual catalog and I'm having
> problems with it returning the category name. It seems the resulting data
> set populates the primaryparentcategory but doesn't populate the
> categoryname, origcategoryname, or #categorydisplayname columns in the
> resulting data set.
>
> CatalogSearch SearchObject = new
> CatalogSearch(CatalogObject.CatalogContext);
>
> SearchObject.CatalogNames = "CAD";
> SearchObject.SqlWhereClause = "[Origcategoryname] = N'Some Category''";
> SearchObject.SearchOptions = new CatalogSearchOptions();
> SearchObject.SearchOptions.ClassTypes = CatalogClassTypes.ProductClass |
> CatalogClassTypes.ProductFamilyClass;
>
> DataSet Results = SearchObject.Search();
>
> Ideally I would like to get the above to work but those fields I need are
> missing. I have searched support.microsoft.com and I don't see any sort
> of fixes among the myriad of catalog SQL updates. Has anyone else been
> able to populate these fields in a search?
>
> Thanks!
> Colin
>
| |
| Vinayak Tadas[MSFT] 2005-08-30, 5:58 pm |
| If you are trying to search for a category and passing ProductClass |
ProductFamilyClass as the classtype you are not going to get any records
since these are mutually confilcting options. Try adding CategoryClass to
the classtypes
Thanks
Vinayak Tadas
Microsoft
http://blogs.msdn.com/vinayakt
This posting is provided "AS IS" with no warranties, and confers no rights.
You assume all risk for your use. © 2002 Microsoft Corporation. All rights
reserved.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm
Get Secure! For more info visit http://www.microsoft.com/security. Please
reply to the newsgroups only
--------------------
From: "Colin Bowern" <colin.bowern@nospam.officialcommunity.com>
References: <ekra6OOrFHA.3604@tk2msftngp13.phx.gbl>
Subject: Re: Searching a Virtual Catalog - Categories Not Returned
Date: Mon, 29 Aug 2005 18:06:52 -0400
Lines: 37
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.3790.1830
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.1830
X-RFC2646: Format=Flowed; Response
Message-ID: <Of3P3XOrFHA.260@TK2MSFTNGP11.phx.gbl>
Newsgroups: microsoft.public.commerceserver.catalog
NNTP-Posting-Host: mail.officialcommunity.net 207.188.77.211
Path: TK2MSFTNGXA01.phx.gbl!TK2MSFTNGP08.phx.gbl!TK2MSFTNGP11.phx.gbl
Xref: TK2MSFTNGXA01.phx.gbl microsoft.public.commerceserver.catalog:1227
X-Tomcat-NG: microsoft.public.commerceserver.catalog
I've determined that those columns may only be valid when returning actual
category records in the result set. Has anyone been able to, outside of
primary parent category, search the virtual catalog based on the original
category name the item resides in?
Thanks,
Colin
"Colin Bowern" <colin.bowern@nospam.officialcommunity.com> wrote in message
news:ekra6OOrFHA.3604@tk2msftngp13.phx.gbl...
> I'm trying to execute a search on a virtual catalog and I'm having
> problems with it returning the category name. It seems the resulting
data
> set populates the primaryparentcategory but doesn't populate the
> categoryname, origcategoryname, or #categorydisplayname columns in the
> resulting data set.
>
> CatalogSearch SearchObject = new
> CatalogSearch(CatalogObject.CatalogContext);
>
> SearchObject.CatalogNames = "CAD";
> SearchObject.SqlWhereClause = "[Origcategoryname] = N'Some Category''";
> SearchObject.SearchOptions = new CatalogSearchOptions();
> SearchObject.SearchOptions.ClassTypes = CatalogClassTypes.ProductClass |
> CatalogClassTypes.ProductFamilyClass;
>
> DataSet Results = SearchObject.Search();
>
> Ideally I would like to get the above to work but those fields I need are
> missing. I have searched support.microsoft.com and I don't see any sort
> of fixes among the myriad of catalog SQL updates. Has anyone else been
> able to populate these fields in a search?
>
> Thanks!
> Colin
>
|
|
|
|
|