|
Home > Archive > Commerce Server General > December 2004 > OrderGroupSearch Problem !!
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 |
OrderGroupSearch Problem !!
|
|
| Ravi Shankar 2004-12-20, 7:49 am |
| I need to get a list of off the Orders in the System from a given date so I
did the following
ordergroupsearchoptions.Columns.add("ordergroup_id")
ordergroupsearchoptions.Columns.add("user_id")
ordergroupsearch.startdatetime = new Date(2004, 11, 16, 0, 0 , 0)
ordergroupsearch.enddatetime = now()
datset = ordergroupsearch.search(ordergroupsearchoptions)
Now I get only 20 rows as the result whereas If I run a SQL query on the
OrderGroup table I get 122 records which I verified is correct data... so why
is ordergroupsearch only returning 20 ?
Regards.
--
Ravi Shankar
| |
| Jason Xu 2004-12-20, 5:48 pm |
| Hi Ravi,
The 20 is the default pagesize. You may want to increase this to a big
value for example 500 and you will see the dataset row number returned
correct.
Below is a piece of code sample (in C#) for you.
***************************************
using System;
using System.Collections;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Web;
using System.Web.SessionState;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.HtmlControls;
using Microsoft.CommerceServer.Runtime;
using Microsoft.CommerceServer.Runtime.Orders;
namespace Microsoft.Solutions.Applications
{
/// <summary>
/// Summary description for WebForm1.
/// </summary>
public class WebForm1 : System.Web.UI.Page
{
private void Page_Load(object sender, System.EventArgs e)
{
Microsoft.CommerceServer.Runtime.Orders.OrderGroupSearchOptions ogso =
new Microsoft.CommerceServer.Runtime.Orders.OrderGroupSearchOptions();
Microsoft.CommerceServer.Runtime.Orders.OrderGroupSearch ogs = new
Microsoft.CommerceServer.Runtime.Orders.OrderGroupSearch();
ogs.OrderContext = CommerceContext.Current.OrderSystem;
ogso.Columns.Add("ordergroup_id");
ogso.Columns.Add("user_id");
ogso.PageSize=500;
ogs.StartDateTime = new DateTime(2004, 11, 16, 0, 0, 0);
ogs.EndDateTime = DateTime.Now;
System.Data.DataSet da = ogs.Search(ogso);
}
#region Web Form Designer generated code
override protected void OnInit(EventArgs e)
{
//
// CODEGEN: This call is required by the ASP.NET Web Form Designer.
//
InitializeComponent();
base.OnInit(e);
}
/// <summary>
/// Required method for Designer support - do not modify
/// the contents of this method with the code editor.
/// </summary>
private void InitializeComponent()
{
this.Load += new System.EventHandler(this.Page_Load);
}
#endregion
}
}
***************************************
Thanks,
Jason
This posting is provided "AS IS" with no warranties, and confers no rights.
You assume all risk for your use. © 2001 Microsoft Corporation. All rights
reserved.
--------------------
Thread-Topic: OrderGroupSearch Problem !!
thread-index: AcTmeAVl04c42DrxQtaUYQpMjcmjQw==
X-WBNR-Posting-Host: 15.219.201.70
From: =?Utf-8?B?UmF2aSBTaGFua2Fy?= <shankycheil@newsgroup.nospam>
Subject: OrderGroupSearch Problem !!
Date: Mon, 20 Dec 2004 01:41:03 -0800
Lines: 18
Message-ID: <6CFB43BA-C14C-41BF-89EA-2253F8E0315D@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:15271
X-Tomcat-NG: microsoft.public.commerceserver.general
I need to get a list of off the Orders in the System from a given date so I
did the following
ordergroupsearchoptions.Columns.add("ordergroup_id")
ordergroupsearchoptions.Columns.add("user_id")
ordergroupsearch.startdatetime = new Date(2004, 11, 16, 0, 0 , 0)
ordergroupsearch.enddatetime = now()
datset = ordergroupsearch.search(ordergroupsearchoptions)
Now I get only 20 rows as the result whereas If I run a SQL query on the
OrderGroup table I get 122 records which I verified is correct data... so
why
is ordergroupsearch only returning 20 ?
Regards.
--
Ravi Shankar
| |
| Ravi Shankar 2004-12-23, 2:46 am |
| Thanks Jason, that has solved my problem. It would help is this is documented
are part of the OrderGroupSearch Object. I assumes (wrongly) that pagesize is
something you'd use if you want the results paginated and not associate it
with the number of rows retuned by default.
Regards.
"Jason Xu" wrote:
> Hi Ravi,
>
> The 20 is the default pagesize. You may want to increase this to a big
> value for example 500 and you will see the dataset row number returned
> correct.
>
> Below is a piece of code sample (in C#) for you.
> ***************************************
> using System;
> using System.Collections;
> using System.ComponentModel;
> using System.Data;
> using System.Drawing;
> using System.Web;
> using System.Web.SessionState;
> using System.Web.UI;
> using System.Web.UI.WebControls;
> using System.Web.UI.HtmlControls;
> using Microsoft.CommerceServer.Runtime;
> using Microsoft.CommerceServer.Runtime.Orders;
>
> namespace Microsoft.Solutions.Applications
> {
> /// <summary>
> /// Summary description for WebForm1.
> /// </summary>
> public class WebForm1 : System.Web.UI.Page
> {
> private void Page_Load(object sender, System.EventArgs e)
> {
> Microsoft.CommerceServer.Runtime.Orders.OrderGroupSearchOptions ogso =
> new Microsoft.CommerceServer.Runtime.Orders.OrderGroupSearchOptions();
>
> Microsoft.CommerceServer.Runtime.Orders.OrderGroupSearch ogs = new
> Microsoft.CommerceServer.Runtime.Orders.OrderGroupSearch();
> ogs.OrderContext = CommerceContext.Current.OrderSystem;
>
> ogso.Columns.Add("ordergroup_id");
> ogso.Columns.Add("user_id");
> ogso.PageSize=500;
>
> ogs.StartDateTime = new DateTime(2004, 11, 16, 0, 0, 0);
> ogs.EndDateTime = DateTime.Now;
> System.Data.DataSet da = ogs.Search(ogso);
> }
>
> #region Web Form Designer generated code
> override protected void OnInit(EventArgs e)
> {
> //
> // CODEGEN: This call is required by the ASP.NET Web Form Designer.
> //
> InitializeComponent();
> base.OnInit(e);
> }
>
> /// <summary>
> /// Required method for Designer support - do not modify
> /// the contents of this method with the code editor.
> /// </summary>
> private void InitializeComponent()
> {
> this.Load += new System.EventHandler(this.Page_Load);
>
> }
> #endregion
> }
> }
> ***************************************
>
> Thanks,
> Jason
>
> This posting is provided "AS IS" with no warranties, and confers no rights.
> You assume all risk for your use. © 2001 Microsoft Corporation. All rights
> reserved.
> --------------------
> Thread-Topic: OrderGroupSearch Problem !!
> thread-index: AcTmeAVl04c42DrxQtaUYQpMjcmjQw==
> X-WBNR-Posting-Host: 15.219.201.70
> From: =?Utf-8?B?UmF2aSBTaGFua2Fy?= <shankycheil@newsgroup.nospam>
> Subject: OrderGroupSearch Problem !!
> Date: Mon, 20 Dec 2004 01:41:03 -0800
> Lines: 18
> Message-ID: <6CFB43BA-C14C-41BF-89EA-2253F8E0315D@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:15271
> X-Tomcat-NG: microsoft.public.commerceserver.general
>
> I need to get a list of off the Orders in the System from a given date so I
> did the following
>
> ordergroupsearchoptions.Columns.add("ordergroup_id")
> ordergroupsearchoptions.Columns.add("user_id")
>
> ordergroupsearch.startdatetime = new Date(2004, 11, 16, 0, 0 , 0)
> ordergroupsearch.enddatetime = now()
> datset = ordergroupsearch.search(ordergroupsearchoptions)
>
> Now I get only 20 rows as the result whereas If I run a SQL query on the
> OrderGroup table I get 122 records which I verified is correct data... so
> why
> is ordergroupsearch only returning 20 ?
>
> Regards.
>
> --
> Ravi Shankar
>
>
|
|
|
|
|