XYZ Corporation would like a report that shows the number of employees who have been with the company more than 20 years, between 15 and 20 years, between 10 and 15 years, between 5 and 10 years, and less than 5 years.
How do you implement this report using Pega?
- Use a SQL Function.
- Use a listView with a custom getContent Activity.
- Use a correlated subreport.
- Use a Connect-SQL rule.
Answer(s): A
Explanation:
To create a report that shows the number of employees with varying years of service, the best approach is to use a SQL function:
SQL Function: Create a SQL function that categorizes the employees based on their years of service. This function can then be used in the report definition to generate the desired output. Implementation: Implement the function to return different categories such as more than 20 years, between 15 and 20 years, etc.
Reference:
Creating SQL functions in Pega
Reveal Solution Next Question