Changing the Cap on Collections

If you cannot retrieve all the records you need to accomplish a task, it is possible to reset the default cap so that the system retrieves the number of records you need.

Note: 
  • Instead of resetting the cap for collections, you can use the Get more rows in the current collection button on the main tool bar.
  • System administrators can override the Retrieve all or Use specified max setting with a system-wide maximum record cap. So, for example, if you set the record cap to display up to 500 items, but the system administrator has set a system-wide maximum of 250, the greatest number of items you can actually display is 250.

To change the cap on records in a collection:

  1. Select View > User Preferences.
  2. In the Data Record Cap area, select the option you want to specify the new cap:
    • Use Default: The system uses the system default cap, usually 200 records.
    • Retrieve All: The system retrieves all records that meet the specified search criteria.
      Caution: 
      Consider carefully before selecting this option. Unlimited retrieval of a collection can degrade system performance.
    • Use Specified Max: Specify the maximum number of records you want to be able to retrieve.

      Note that transferring a large number of records to your system can degrade performance.

    If the Use Default option is selected, -1 is displayed in this field. If the Retrieve All option is selected, 0 is displayed here.

  3. Click OK.
  4. To refresh the collection in the current form, select Actions > Refresh
Note:  The cap you designate applies to all collections in all forms.