How to track the number of requested feedback via BI Publisher

Summary:

How to track the number of requested feedback via BI Publisher

Content (please ensure you mask any confidential information):

Hi,

we would like to generate a report which gives the possibility to extract for each employee the number of the requested feedbacks. We built the following query:

SELECT *

FROM HRA_FEEDBACK_REQUEST

WHERE REQUESTED_BY_PERSON_ID = REQUESTED_FOR_PERSON_ID

In this way we obtained the pieces of information of the HRA_FEEDBACK_REQUEST table, assuming that the employee requires for himself/herself a feedback to another employee (his/her Manager or a peer). We would like to add another column that allows to track for each employee the number of the requested feedbacks.