1000 records max on order manager?

[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!

[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>      

[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.

[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.

[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.