To help with 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. A maximum of 500 rows are returned.
The Query Runner is available for Pega Cloud customers who use a Postgres database or for customers using an Oracle database on-premises or on the Cloud. You need the PegaRULES:DatabaseAdministrator role you must have the PegaRULES:DatabaseAdministrator role or the pxViewandSelectQuery privilege in Data- and Rule- in your access group to access the Query Runner.