With the Page size for Multi-Record Update preference,
you can perform a multirecord update on result sets that are greater
than 100 records, provided that the site maximum is greater than 100.
Multirecord update only affects the records that are shown on the
current result set page. The number of records that you choose to
run multirecord update on is determined by these values:
- The value of the Number of rows in one page preference
- The value of the Page size for Multi-Record Update preference
You set these preferences in the ClearQuest® User Preferences dialog box.
When you begin a multirecord update, one of these scenarios occurs:
- If the number of records in your result set is less than or equal
to the Number of rows in one page value and
less than or equal to the Page size for Multi-Record Update value,
the Multi-Record Update tab opens.
For example, suppose the Number
of rows in one page value is 20 and the Page
size for Multi-Record Update value is 20. You run a query
that returns a result set with 5 records. Five records are fewer than
the 20 records that are specified in the Number of rows
in one page and the Page size for Multi-Record
Update preferences. Therefore, the Multi-Record
Update tab opens.
- If the number of records that are displayed on the result set
page is less than the Page size for Multi-Record Update value
and there are records in the result set that are not currently displayed,
then the Increase Page Size dialog box opens.
You can rerun the query to include more records in the result set,
though the query results might change. You can continue with the multirecord
update with the records in the current result set. Or, you can cancel
the multirecord update.
For example, suppose the Number
of rows in one page value is 20 and the Page
size for Multi-Record Update value is 30. You run a query
that returns a result set with 22 records. The result set displays
20 of the 22 records because the Number of rows in one
page value is 20. The Increase Page Size dialog
box opens. Because the Page size for Multi-Record Update value
allows up to 30 records to be displayed, you can rerun the query to
include up to 30 records. You can cancel the multirecord update. Or,
you can continue the multirecord update with the 20 records that are
currently in the result set.
- If the number of records that are displayed on the result set
page is greater than the Page size for Multi-Record Update value,
then the Decrease Page Size dialog box opens.
You can run the query again to decrease the number of records in the
multirecord update result set, although the query results might change.
Or, you can cancel the multirecord update.
For example, suppose
the Number of rows in one page value is 50
and the Page size for Multi-Record Update value
is 30. You run a query that returns a result set with 46 records and
they are all currently shown on the page. The Decrease Page
Size dialog box opens. The result set of 46 records is
larger than 30, the number of records that multirecord update can
operate on. You can rerun the query to display only 30 records on
which to run the multi-record update, or you can cancel the multirecord
update.