Share this page

# Limiting Records Displayed in Grids

To optimize performance, the number of records retrieved and displayed in ALM grids is limited. The limits include:

- Maximum number of records displayed in a grid.

- Maximum number of records displayed for each group when a group by filter is applied to a grid.

To bypass the limit and display all relevant records, users can click the Retrieve all <x> results link in the window or dialog box.

You can change the default limits for all site projects, or individually for each project. When you change the limits for a project, they override default limits, or the values defined by the FETCH_LIMIT or GROUP_FETCH_LIMIT parameters.

To change the default number of records displayed in grids for all site projects:

Add and configure the FETCH_LIMIT and GROUP_FETCH_LIMIT parameters in the Site Configuration tab. For details, see Setting ALM Configuration Parameters.

To change the default number of records displayed in grids per project:

1. In Site Administration, click the Site Projects tab.

2. In the Projects list, double-click the project for which you want to change the default limits for records displayed in a grid.

3. Select the DATACONST table.

4. In the SQL pane, type an SQL INSERT statement to insert a row into the table with the following values:

   - In the DC_CONST_NAME column, insert the parameter name FETCH_LIMIT or GROUP_FETCH_LIMIT.

   - In the DC_VALUE column, insert a value for the parameter.

For example, to change the value of the FETCH_LIMIT parameter to 50, type the following SQL statement into the SQL pane:

    insert into dataconst values ('FETCH_LIMIT', '50')

5. Click the Execute SQL button. The new row is added to the DATACONST table.

Back to top

https://admhelp.microfocus.com ALM 8942
Tips to improve your search results... ALM Help Center ALM Help Center ALM Help 15.5-15.5.1 All View Local Help Center View Online Help Center back Go back in browser history forward Go forward in browser history Remove search highlights next topic Go to next topic previous topic Go to previous topic Print the current topic Version: