Skip to main content


Advanced query design

The knowledge of how to configure reports might not be enough to create accurate reports. You can use multiple solutions, one superior to the others, to solve the same problem. Alternatively, an ideal solution might not be possible with the data that already exists.

Learn how you can create data to simplify your queries and how to plan your data storage to support your reporting needs early in the process.

After completing this module, you should be able to:

Produce queries that are inclusive or exclusive of the 1:M relationship.
Produce queries based on generated or reformatted data.
Produce queries that include SQL functions.

Available in the following mission:

Reporting Design v4

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