Getting only one employee in Alert composer
Summary
Getting only one employee in Alert composerContent
Hi All,
I created one alert composer to get the employees who's comp time is greater than or equal 35. There are four employees having more than 35 comp time. But in the alert i am getting alert notification for only one employee.
Here is my query :
exists (select 'x' from (select paed.person_id,sum(paed.value) from ANC_PER_ACRL_ENTRY_DTLS paed where paed.type = 'ORA_ANC_COMPTME' and paed.person_id = ${PersonId} group by person_id having sum(paed.value)>=35))
Can any one help me what will be the issue?
0