Windows Server

Ravi Shankar · Guest

I've extended the OrderForm and LineItem dictionaries to store certain
additional properties. I've extended the DB Tables (appropriately) and can
see these values being persisted into these fields.

Now, I wanted to use the OrderGroupSearchOptions to ADD these to list of
columns returned by OrderGroupSearch.Search Method but that does not seem to
work. Additionally if I tried setting the
OrderGroupSearchOptions.FetchOrderFormInformation to TRUE but that did not
work too... I go a list of fields which did not contain my custom/extended
fields.

Part of a very critical requirement so appreciate a quick response.

Regards.
--
Ravi Shankar

Nihit Kaul [MSFT] · Guest

Hi Ravi,

What is the search you are making (on OrderGroup properties or on some
extended property on LineItem/OrderForm)?

Also what are the other settings on the OrderGroupSearchOptions that you
are passing in (for e.g. FetchLineItemInformation)?

Thanks,
Nihit Kaul[MSFT]
Commerce Server
http://blogs.msdn.com/nihitk

This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm

--------------------
Thread-Topic: How to expose Custom Props on OrderForm or LineItem through
Search
thread-index: AcTisvz9Gx5CH4CLTnKwxUt7Dmc8uQ==
X-WBNR-Posting-Host: 15.211.169.100
From: =?Utf-8?B?UmF2aSBTaGFua2Fy?= <shankycheil@newsgroup.nospam>
Subject: How to expose Custom Props on OrderForm or LineItem through Search
Date: Wed, 15 Dec 2004 06:33:04 -0800
Lines: 16
Message-ID: <0EDEFF16-A3F9-4B42-BAE2-A2E1096B3CDB@microsoft.com>
MIME-Version: 1.0
Content-Type: text/plain;
charset="Utf-8"
Content-Transfer-Encoding: 7bit
X-Newsreader: Microsoft CDO for Windows 2000
Content-Class: urn:content-classes:message
Importance: normal
Priority: normal
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.0
Newsgroups: microsoft.public.commerceserver.general
NNTP-Posting-Host: TK2MSFTNGXA03.phx.gbl 10.40.1.29
Path: cpmsftngxa10.phx.gbl!TK2MSFTNGXA03.phx.gbl
Xref: cpmsftngxa10.phx.gbl microsoft.public.commerceserver.general:15247
X-Tomcat-NG: microsoft.public.commerceserver.general

I've extended the OrderForm and LineItem dictionaries to store certain
additional properties. I've extended the DB Tables (appropriately) and can
see these values being persisted into these fields.

Now, I wanted to use the OrderGroupSearchOptions to ADD these to list of
columns returned by OrderGroupSearch.Search Method but that does not seem
to
work. Additionally if I tried setting the
OrderGroupSearchOptions.FetchOrderFormInformation to TRUE but that did not
work too... I go a list of fields which did not contain my custom/extended
fields.

Part of a very critical requirement so appreciate a quick response.

Regards.
--
Ravi Shankar

Ravi Shankar · Guest

This is what my code looks like...

Dim oConsoleDebugContext As ConsoleDebugContext = New
ConsoleDebugContext(DebugMode.Debug)
Dim oSiteResources As CommerceResourceCollection = New
CommerceResourceCollection("Store")
Dim oOrderResource As CommerceResource =
oSiteResources("Transactions")
Dim sTransactionConnectionString As String =
oOrderResource("connstr_db_Transactions")
Dim oOrderContext As OrderContext = New
OrderContext(sTransactionConnectionString, oConsoleDebugContext)
Dim oOrderSearchOptions As OrderGroupSearchOptions = New
OrderGroupSearchOptions
Dim oOrderSearch As OrderGroupSearch = New
OrderGroupSearch(oOrderContext)
Dim oDSOrders As DataSet

oOrderSearchOptions.FetchOrderFormInformation = True

oOrderSearch.StartDateTime = fromDate
oOrderSearch.EndDateTime = toDate

oDSOrders = oOrderSearch.Search(oOrderSearchOptions)

This only returns a set of 19 properties which does not include my custom
extended properties.. like for example I have a field called customer code
(customer_code) which is stored in a similar field in the OrderFormHeader
Table..

In the site it is accessed as
PurchaseOrder.OrderForms(0).Item("customer_code") but how would it be called
in the search option..

If I use oOrderSearchOptions.Columns.Add("OrderForm(0).customer_code") it
gives me an internal error during the search method.

Regards.

"Nihit Kaul [MSFT]" wrote:

	Windows Server Forum Index -> Commerce Server	All times are GMT
Page 1 of 1