Not able to scroll beyond the 100th dropdown option of Search criteria field in Find & Reserve Form

book

Article ID: 131507

calendar_today

Updated On:

Products

CA Test Data Manager (Data Finder / Grid Tools)

Issue/Introduction



After creating a Legacy Find & Reserve model based on an environment holding a MS SQL Server database table, and enabled one of the columns in the search criteria as a dropdown field, users are not able to scroll through more than the 100th option in the dropdown list. The list only shows 100 options, whereas the valid entries in the database contain more than a hundred entries (about 298 entries). Is there a property setting we can adjust to show all available options in the list?

Environment

Release:
Component: TDMWBP

Resolution

TDM Portal is working as designed. The value of 100 is hardcoded in front end, and can not be modified.

The dropdown search fields are meant to be used for “FIND DATA” refinement and fetch only 100 records at max due to the usability and performance. If a user needs to see all the records, they can just hit “FIND DATA”, which in turn also fetches only 100 records, but supports pagination, so if you’d scroll all the way down, it is going to fetch next 100 records. In other words, If a user really needs to see some values in the dropdown and they do not, they should refine the search term. If a user does not know what data is stored in the db columns and does not know what to put in the search field, they can just hit “FIND DATA”, study the values and then refine the result.

Additional Information

For more information regarding Find & Reserve in TDM Portal, see:
"Configure Test Data Reservation Service"
https://docops.ca.com/ca-test-data-manager/4-7/en/provisioning-test-data/configure-test-data-reservation-service