PEGACPBA24V1 practice question 6 of 25

A manager requests a report that contains the following columns: Create Date, Case ID, Create Operator, and Work Status. You must sort the cases so the case with the most recent create date appears at the top of the list and descends in order. How do you design the report definition to support this requirement?

Full set: 144 questions
Answer options
A: Select Highest to Lowest sort type for Create Date. Correct answer
B: Make the Create Date the first column in the report.
C: Select Lowest to Highest sort type for Create Date.
D: Add a filter condition where Create Date is greater than the current date.
Correct Answer:
A. Select Highest to Lowest sort type for Create Date.
Explanation

The requirement is to sort cases so the most recent 'Create Date' appears at the top. This is a descending sort order. In a Pega report definition, sorting a date or numeric column from "Highest to Lowest" arranges the records in descending order. The highest date value is the most recent date, fulfilling the manager's request to see the newest cases first.

Why Incorrect

B. Making the Create Date the first column only changes its display position in the report grid; it does not control the sort order of the records.
C. Selecting "Lowest to Highest" would sort the cases in ascending order, placing the oldest cases at the top, which is the opposite of the requirement.
D. This is a filter condition, not a sorting option. It would incorrectly attempt to show only cases created in the future, resulting in an empty report.

References

1. Pega Academy: Business Architect Mission

Module: Reporting

Topic: Creating a report. This module explains that to sort data

you use the sorting options in the report definition's Query tab

and a descending sort (Highest to Lowest) is used to show the most recent items first.

2. Pega Platform Documentation: Creating a report definition

Section: Report Definition Query tab. The documentation specifies that the "Sort" section on the Query tab is used to define the record order. For date properties

selecting "Highest to Lowest" as the "Sort Type" configures a descending sort.

Scroll to Top