Issue
When executing a query using the query runner, a maximum of 5000 results are displayed.
Symptoms and Impact
The query runner displays a maximum of 5000 results.
Steps to Reproduce
- In the header of Dev Studio, click > > > .
- Click the Query Entry tab.
- In the field, select the database that you want to run the query against.
- In the field, enter the query that you want to test.
- Click .
Root Cause
This is a documented limitation in the Pega Platform.
For more information, refer to Running SQL queries on Pega Cloud
Solution
An enhancement request to increase the documented limit has been raised, but it not assigned to a specific release.
If a query must be executed from within the Pega Platform that is expected to display more than 5000 results, consider using the following alternative options:
- A report definition.
- A BIX Extract