Setting the user preference for record caps

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

Note: 
  • Before you reset the cap for collections, consider just using the Get more rows in the current collection button on the main tool bar. This allows you to view more records without having to change the cap.
  • 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 in one retrieval is 250.
  • Any cap you designate applies to all collections in all forms.

To change the user-level cap on records in a collection:

  1. Select View > User Preferences.
  2. In the User Data Record Cap section, select the option you want for the new cap:
    • Use Default: The system uses the system default cap of 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 at a time.
      Note: 
      • Even with this setting, you cannot retrieve a number of records greater than a Farm-wide record cap or a User Preferences Max Record Cap setting.
      • Transferring a large number of records to your system can degrade performance.

      If you select the Use Default option, -1 displays in this field. If you select the Retrieve All option, 0 displays here.

  3. Click OK.

To refresh the collection in the current form, select Actions > Refresh.