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 questionsThe 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.
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. ---
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.
Keep practicing
Take the free PEGAPCBA87V1-PRACTICE-QUESTIONS practice test
Ten exam-style questions with answers and explanations, plus the exam facts and study guides.
More questions
Other PEGAPCBA87V1-PRACTICE-QUESTIONS practice questions
- Question 1A reservation process allows customers to reserve a flight, hotel room, and rental car as…
- Question 2Which requirement do you satisfy by using a Wait step?
- Question 3Which scenario is a use case for the Wait step?
- Question 4Sales managers must be able to approve sales quote proposals by email and from a mobile d…
- Question 6You are assigned to a pega implementation project as a pega business architect. Which tas…
- Question 7An order form provides four options from which customers select one option. According to …
