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

1. In the header of Dev Studio, click Configure > System > Database > Query Runner.
2. Click the Query Entry tab.
3. In the Choose your database field, select the database that you want to run the query against.
4. In the SQL query field, enter the query that you want to test.
5. Click Run.

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

References

• Running SQL queries on Pega Cloud
• Data extraction
• Report definitions