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.
Add and configure the FETCH_LIMIT and GROUP_FETCH_LIMIT parameters in the Site Configuration tab. For details, see Setting ALM Configuration Parameters.
-
In Site Administration, click the Site Projects tab.
-
In the Projects list, double-click the project for which you want to change the default limits for records displayed in a grid.
-
Select the DATACONST table.
-
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.
-
-
Click the Execute SQL button. The new row is added to the DATACONST table.
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')