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:

Select View > User Preferences.
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.
Click OK.
To refresh the collection in the current form, select Actions > Refresh

Note: The cap you designate applies to all collections in all forms.