Configuring Siebel Business Applications > Configuring Special-Purpose Applets > Customizing a Hierarchical List Applet >

Limiting the Number of Records That Siebel CRM Returns in a Hierarchical List Applet

If you define a hierarchical list applet, then the business component returns all the records that make up the hierarchy. It does this to construct the hierarchy of records. In general, Siebel CRM cannot return more than ten thousand records. If a query returns more than ten thousand records, then Siebel CRM does not display the applet and the user might encounter an error that is similar to the following:

There were more rows than could be returned. Please refine your query to bring back fewer rows.

To limit the number of records that Siebel CRM returns in a hierarchical list applet

• Use one of the following techniques to make sure that the applet does not return more than ten thousand rows:
  • Create a search specification on the business component or on the applet. For more information, see Options to Filter Data Displayed in an Applet.
  • Use a predefined query for the view. For more information, see Guidelines for Modifying a Predefined Query.