Skip to main content


Advanced query design


4 Topics

1 hr 10 mins

Visible to: All users
Advanced Pega Platform 8.5 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 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 simplify a query is a technique that can be leveraged. Also, the best way to store data to facilitate reporting needs to be made early on; data query ability cannot 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 SQL Functions
Produce queries that contain complex SQL

Available in the following mission:

Reporting Design v1

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