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 create the hierarchy of records. Siebel CRM cannot typically return more than ten thousand records. If a query returns more than ten thousand records, then it 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 configurations 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 That Siebel CRM Displays in an Applet.

  • Use a predefined query for the view. For more information, see Guidelines for Modifying a Predefined Query.