Click HERE to see how Saviynt Intelligence is transforming the industry. |
05/14/2024 05:57 AM
Hello,
How do I expand the number of rows displayed in the analytics report results? Presently, it only shows 5000 rows, yet the query fetches more. Could we introduce pagination to streamline data retrieval in analytics reports?
05/14/2024 05:59 AM
To expand the number of rows displayed in the analytics report results, you can increase the value of the "Ws_max_records_returned_analytics_es" configuration in Saviynt. By default, this configuration limits the number of rows returned in an analytics report to 5000.
To increase this limit, you can follow these steps:
1. Login to the Saviynt Admin portal.
2. Navigate to the Admin section.
3. Search for the "Ws_max_records_returned_analytics_es" configuration.
4. Select the configuration, and update the value to the desired number of rows you want to display. For example, you can set it to 10000 to display 10000 rows in the analytics report.
5. Save the configuration changes and restart the Saviynt application for the changes to take effect.
Once you have updated the configuration, you should be able to view a higher number of rows in the analytics report results.
Regarding pagination, Saviynt does support pagination in analytics reports. You can specify the number of rows to be fetched per page using the "size" parameter in the API request. By default, the size is set to 500. You can increase this value to fetch a larger number of rows per page. Additionally, you can use the "from" parameter to specify the starting index of the records to fetch, allowing you to navigate through different pages of the result set.
By utilizing pagination, you can streamline data retrieval in analytics reports and fetch the required number of rows based on your needs.
05/14/2024 09:01 PM
You can't change this configuration due to performance issue
select * from configuration where name like '%MAX_RECORDS%'