VARA to Grid widget only shows 100 entries
Article ID: 395619
Updated On:
Products
Issue/Introduction
When attempting to view a VARA to Grid widget in a dashboard where the variable has over 100 rows, only 100 are shown in the grid.
This can be reproduced using these steps:
1) Created a SQL or SQLI VARA object with a simple select that brings back over 100 rows - preview the variable in the AWI
2) In a dashboard, add the VARA to Grid widget, select configuration and set the data source to the VARA object
3) Save the changes and view the dashboard
You will see that only 100 values were available to be displayed.
Environment
Automation Engine V 21.0.x and V 24.x
Cause
Product Design/Limitation
Resolution
The behavior is by design - only 100 rows will be shown in the grid.
The reason for this design is that if there are more than 100 rows, the grid may become very hard to read and it can also affect overall performance of the system
Additional Information
Note: We will update the information as Maximum of 100 values can be shown, into future documentation (24.4 or later)
Feedback
