PER_PERSON_ALLOCATED_TASKS_DFF SQL Type

Content

Hello Guys,

We would create a task to allow the employee to confirm their Hire Date. We used "Configurable Form" by configuring the DFF "PER_PERSON_ALLOCATED_TASKS_DFF" with a SQL type Field.

We just try to use this SQL expression:

select DISTINCT pos.DATE_START, PP.PERSON_NUMBER
from PER_PERIODS_OF_SERVICE pos
JOIN PER_ALL_ASSIGNMENTS_F PAF on POS.PERIOD_OF_SERVICE_ID = PAF.PERIOD_OF_SERVICE_ID
JOIN PER_PEOPLE_F PP ON PP.PERSON_ID = PAF.PERSON_ID
where paf.PERSON_NUMBER = 31790

In this way, We had the possibility to bring in the field the Start Date, but we need to extract the information of current pending worker, is there a way to keep in a query a dynamic person_id of the employee?