Skip to main content


Advanced query design


4 Topics

25 mins

Visible to: All users
Advanced Pega Platform 8.3.1 English
This content is now archived and is no longer updated. Progress is not calculated. Pega Cloud instances are disabled, and badges are no longer awarded. Click here to continue your progress in the latest version.

It is not enough just to know how to configure reports. There can be multiple solutions to the same problem, one superior to the others. There can be situations where an ideal solution is not possible using the data that already exists. Creating data to simply a query is a technique that can be leveraged. Also, the decision how best way to store data to facilitate reporting needs to be made early on; data query ability should not be an afterthought.

After completing this module, you should be able to:

Produce queries that reference ancestors within a case hierarchy
Produce queries based on generated or reformatted data
Produce queries that include correlated subqueries
Produce queries that contain complex SQL

Available in the following mission:

Lead System Architect

We'd prefer it if you saw us at our best.

Pega Academy has detected you are using a browser which may prevent you from experiencing the site as intended. To improve your experience, please update your browser.

Close Deprecation Notice