Discussions
Report of employees present in the company today
Hello everyone, I have to say that factorial has very good development support.
I have some rudiments of programming and I need to compose a query that generates a report of the employees actually present in the company in the current day.
I generated a complete table with SELECT * from EMPLOYEES but I couldn't find any field that could help me. I think I'm looking in the wrong table. Can someone tell me the parameter to use? I guess it must be something similar to presence. Thank you all.
Hi Pietr,
You can use the field terminated_on available in the employees endpoint, if the field is null the employee is still currently working for the company
https://apidoc.factorialhr.com/reference/get_api-2025-01-01-resources-employees-employees
Hope it helps!
thank you but this field is for person who are hired in the company. I need to generate report person who are phisically presente in the company at same report request day.