Hello All,
I need to review orders for  a aspecified time period and extract the
follwing items (among others)
1. The dicount code entered
2. The shipping amount paid

Which table stores this information? I suspect that this is stored as
binary data.

If I need to get something lile the order._shipping_total amount from
the BinaryData blobs, how is this done?

Thanks,
-tomas


/*-------------------------------
* Tomas Vera
* tomas (at) sbcglobal (dot) net
*-------------------------------
*/

[ Post a follow-up to this message ]

Hi Tomas,

The best way to handle this situation would be to add an additional column
to the table on which you want to store the information, for e.g.  add a
_shipping_total column on the OrderGroup table and then any property value
with the same name would get persisted to this explicit column. Thus if you
set
myOrder["some_property"] = 123.45;
and then save the order and the OrderGroup table has column named
"some_property" then the data should get stored in this column and you can
search on this column including searching programmatically using the CS
APIs.

In case your data is already present in the database blob column then your
only option would be to extract it using either some unsupported tool like
the OrderFormViewer at the following GotDotNet site, or to write some
custom code to handle this.


http://www.gotdotnet.com/workspaces...3-96dc-41de-9ca
0-b7f284a8c113

Hope this helps.

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
--------------------
From: Tomas Vera <tavera@NO_SPAM_sbcglobal.net>
Newsgroups: microsoft.public.commerceserver.general
Subject: Retrieving info from order
Message-ID: <uh4sb19vajihk3q88ars3arc2lh19efaku@4ax.com>
X-Newsreader: Forte Free Agent 2.0/32.652
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
Lines: 21
NNTP-Posting-Host: 69.233.96.202
X-Complaints-To: abuse@prodigy.net
X-Trace: newssvr21.news.prodigy.com 1119752960 ST000 69.233.96.202 (Sat, 25
Jun 2005 22:29:20 EDT)
NNTP-Posting-Date: Sat, 25 Jun 2005 22:29:20 EDT
Organization: SBC http://yahoo.sbc.com
X-UserInfo1:
TSU[@I_A\S@[SVP[KROFOFXBWR\HPCTL@XT^OBPLAH[\RSAANVUEAE[Y
ETZPIWWI[FCIZA^NBFXZ
_D[BFNTCNVPDTNTKHWXKB@X^B_OCJLPZ@ET_O[G\XSG@E\G[ZKVLBL^CJINM@I_K
VIOR\T_M_AW_
M[_BWU_HFA_]@A_A^SGFAUDE_DFTMQPFWVW[QPJN
Date: Sun, 26 Jun 2005 02:29:20 GMT
Path:
TK2MSFTNGXA01.phx.gbl!TK2MSFTFEED02.phx.gbl!tornado.fastwebnet.it!tiscali!ne
wsfeed1.ip.tiscali.net!in.100proofnews.com!in.100proofnews.com!border2.nntp.
dca.giganews.com!border1.nntp.dca.giganews.com!nntp.giganews.com!newscon06.n
ews.prodigy.com!prodigy.net!newsmst01b.news.prodigy.com!prodigy.com!postmast
er.news.prodigy.com!newssvr21.news.prodigy.com.POSTED!2080ae30!not-for-mail
Xref: TK2MSFTNGXA01.phx.gbl microsoft.public.commerceserver.general:2929
X-Tomcat-NG: microsoft.public.commerceserver.general

Hello All,
I need to review orders for  a aspecified time period and extract the
follwing items (among others)
1. The dicount code entered
2. The shipping amount paid

Which table stores this information? I suspect that this is stored as
binary data.

If I need to get something lile the order._shipping_total amount from
the BinaryData blobs, how is this done?

Thanks,
-tomas


/*-------------------------------
* Tomas Vera
* tomas (at) sbcglobal (dot) net
*-------------------------------
*/

[ Post a follow-up to this message ]