Skip to main content

         This documentation site is for previous versions. Visit our new documentation site for current releases.      

This content has been archived and is no longer being updated.

Links may not function; however, this content may be relevant to outdated versions of the product.

Query Runner landing page for testing SELECT statements

Updated on November 29, 2016

When developing and debugging applications, you can test SELECT statements from the Query Runner landing page. You can run queries against non-BLOB columns in your database and view the results on the landing page or export the results to an Excel spreadsheet or PDF file. This functionality is available for Pega Cloud customers who use a Postgres database or for customers using an Oracle database on-premises or in the cloud.

To access and use this landing page, you must have the PegaRULES:DatabaseAdministrator role or the pxDBSelectQuery privilege in Data- and Rule- in your access group. You access the landing page by clicking Designer Studio > System > Database > Query runner.

Query Entry tab

You enter and run the SELECT statement on the Query Entry tab. The following example shows a query and its results.

Query Runner example query and results

Query Runner example query and results

History tab

The History tab shows a list of queries that have previously been tested. You can click a query and export its results. Queries that are too long to display in the list are partially displayed followed by an ellipsis. You can view the entire query by clicking it in the Select Query column.

Query Runner History tab

Query Runner History tab

Have a question? Get answers now.

Visit the Support Center to ask questions, engage in discussions, share ideas, and help others.

Did you find this content helpful?

Want to help us improve this content?

We'd prefer it if you saw us at our best. is not optimized for Internet Explorer. For the optimal experience, please use:

Close Deprecation Notice
Contact us