For more information, please refer to this announcement explaining best practices for getting answers to questions.
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.