Page 1 of 1
1000 records max on order manager?
Posted: Fri Apr 24, 2009 6:35 am
by jhonrath
On the order default screen, it seems we can only get 1000 records to display.
We need to have all 1500 orders in the system displayed at once.
We do have the commercebuilder API and I went into ORderDataSource and changed the Max from 1000 to 5000, and this did not seem to make a difference.
Am I missing something?
Thanks!
Re: 1000 records max on order manager?
Posted: Fri Apr 24, 2009 6:44 am
by mazhar
Try by editing Website/Admin/Orders/Default.aspx page and then locate
Code: Select all
<asp:DropDownList ID="PageSize" runat="server">
<asp:ListItem Text="10 per page" Value="10"></asp:ListItem>
<asp:ListItem Text="20 per page" Value="20" Selected="true"></asp:ListItem>
<asp:ListItem Text="50 per page" Value="50"></asp:ListItem>
<asp:ListItem Text="show all" Value=""></asp:ListItem>
</asp:DropDownList>
and add one more entry with 1500
Code: Select all
<asp:DropDownList ID="PageSize" runat="server">
<asp:ListItem Text="10 per page" Value="10"></asp:ListItem>
<asp:ListItem Text="20 per page" Value="20" Selected="true"></asp:ListItem>
<asp:ListItem Text="50 per page" Value="50"></asp:ListItem>
<asp:ListItem Text="1500 per page" Value="1500"></asp:ListItem>
<asp:ListItem Text="show all" Value=""></asp:ListItem>
</asp:DropDownList>
Re: 1000 records max on order manager?
Posted: Tue Apr 28, 2009 6:04 am
by jhonrath
Thanks for the help. However, this did not work. I did attempt it.
The page size isn't the issue, the returned records are only 1000. I need to get all 1500 back with the data set that is bound to the grid.
Thanks.
Re: 1000 records max on order manager?
Posted: Tue Apr 28, 2009 9:15 am
by AbleMods
The object data source is limiting the returned row count to 1,000.
Since the page is designed to use the compiled .Search() method in the OrdersDataSource class, I don't believe there is a way to change it. The whole page would have to be redesigned to pulls orders from the table using a different technique.
Depending on your needs, it might be much simpler to design a new separate page just for your specific functionality. Then you could control the rows returned and not have the data class search method limitations. Not an ideal solution but your options are pretty limited at this point.
Re: 1000 records max on order manager?
Posted: Tue Apr 28, 2009 9:28 am
by mazhar
Please try following fix as well, locate following code in your Orders/Default.aspx page
Code: Select all
<asp:Parameter Name="criteria" Type="Object" />
and replace it with following and then try
Code: Select all
<asp:Parameter Name="criteria" Type="Object" />
<asp:Parameter Name="maximumRows" Type="Int32" DefaultValue="1500" />
<asp:Parameter Name="startRowIndex" Type="Int32" DefaultValue="0" />
<asp:Parameter Name="sortExpression" Type="String" DefaultValue="" />
Also do not forget to change page size to your desired amount as suggested above.