Is there a Pega version of the RANK () OVER (PARTITION BY) function for a Report Definition?
Does Pega have its own version of this function?
For example as SQL it would be:
select
employee_name,
salary,
RANK() OVER (PARTITION BY department ORDER BY salary)
from employees
Is there anyway to replicate this in a Report Definition?
***Edited by Moderator Marissa to update General to Product; update Product details***
Updated: 14 Jun 2021 7:38 EDT
Pegasystems Inc.
IN
It seems like we cannot implement this by using existing functions.
We can get the results but for showing the rank we may need to use UDF.
Please find the below screenshot for the implementation of the above requirement except for rank in Pega.
Pegasystems Inc.
US
Another alternative is to set up a database view that is populated by your desired query, and associate that view with a class in Pega, just like you would with a database table. The Pega class does not see any difference between tables and views.
Cognizant
GB
Thanks for the helpful response.
If there's new data consistently going into the table, would the view in pega replicate this or does the fact the views don't update with new data mean that the class will always display the same information.
