Enabling Recordset Query Limitation

Recordset Query Limitation is configured on a per-entity basis. For example, if you want to limit the number of records that appear in views of the Form Templates and Database Objects Persons and Companies entities, you need to enable Recordset Query Limitation on both entities.

Enabling Record Query Limitation is a two-step process. First, you enable the feature on the particular entity and then you configure the maximum number of records that can be displayed in a view for each group or user who has access to the entity.

Follow these steps to enable Recordset Query Limitation for a particular entity:

1. Open or create a view of the Entities service that includes the entity you want to -configure.
   • You must be logged in as a user who has System Administrator privileges to make changes to an entity.
      
2. Double-click the entity's entry in the view to open the entity's record.
3. Click the Configuration tab.
4. Select the Enable Recordset Query Limitation option.
   
    
5. Click the Security tab.
6. Double-click a group's entry in the list to open its EntityGroupPermissions record.
7. Configure the group's Recordset Query Limitation.
   • To limit the number of records in a view, select the Recordset Query Limited option and enter the maximum number of records to display in a view in the field provided.
   • With the configuration settings shown below, members of the Users group can see a maximum of 20 records in a view.
     
     
   • If you want a group to have access to all entity records within a view, leave the Recordset Query Limited option cleared.
   • With the configuration settings shown below, there is no limit to the number of records that can appear within a view for members of the Administrators group.
     
     
8. Click OK to return to the Entities record.
9. Configure the other groups as necessary.
10. Click the Users sub-tab.
11. Configure the Users' Recordset Query Limitation settings, as necessary.
    • The configuration for Users is the same as the configuration for the Groups.
       
12. Click Save and Close to save your changes and close the entity record.