- What is ranking in RD
- How to design a RD that shows the no of hours spent by a user to work on the case and in which class this RD should be created?
- How to configure filters in RD dynamically
Ranking in RD is similar to SQL RANK() function. If you scored 90 mark and i scored 80 then your rank is 1 and my rank is 2.
If you want to rank user by the hrs spent, create an RD on the class that contains those data. you can use aggregate function like SUM on hrs spent property and group by user. To apply filters dynamically - say you want to filter by a specific user, then you may use user = param.user and then pass the value. if you have any other criteria, you may also define corresponding parameters and pass that as param to this RD.
Hi @Karuppan all the three questions are different ,like the 2nd question is not related to ranking and so do the third question ,are there any alternate approach for 1,2,3?How can we configure this ranking in a RD ?then 2 and 3 are separate questions,for example if i select a param filter so how to configure that dynamically at runtime?