Skip to main content

Module

Advanced query design

5 Topics

1 hr 20 mins

Visible to: All users
Advanced Pega Platform 8.6 English
Verify the version tags to ensure you are consuming the intended content or, complete 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 v2

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