PEGAPCBA87V1-PRACTICE-QUESTIONS practice question 5 of 15

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. How do you design the report to support this requirement?

Full set: 74 questions
Answer options
A: Select Highest to Lowest sort type for Create Date. Correct answer
B: Select Lowest to Highest sort type for Create Date.
C: Make the Create Date the first column in the report.
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 one appears first. Date and time values are stored numerically, where a more recent date has a higher value than an older date. To display the highest values first, you must apply a descending sort order. In the Pega Platform™ Report Definition rule, the "Highest to Lowest" sort type configures a descending sort, which will list the cases from the most recent create date to the oldest.

Why Incorrect

B. Select Lowest to Highest sort type for Create Date. This configures an ascending sort, which would incorrectly place the oldest case at the top of the report.
C. Make the Create Date the first column in the report. The display order of columns is independent of the data's sort order. Sorting is configured separately in the report's query settings.
D. Add a filter condition where Create Date is greater than the current date. This is a filter, not a sort function. It would incorrectly attempt to show cases created in the future, likely resulting in an empty report. ---

References

1. Pega Documentation: Report Definition rule form - Query tab. In the "Column information" section, the documentation explains the "Sort Type" field. It specifies that "Highest to Lowest" applies a descending sort order (for example, Z-A or 9-1), which for a date property, places the most recent dates first.

Source: Pega Platform™ 8.7 Documentation, "Report Definition rule form - Query tab".

2. Pega Academy: Low-Code App Builder (8.7) Mission, Module: Creating reports, Lesson: Organizing report results. This lesson details how to configure a report to meet business requirements, including sorting. It explicitly states that to show the newest items first, a descending sort order should be applied to the relevant date property.

Source: Pega Academy, "Low-Code App Builder" courseware for version 8.7.

Scroll to Top