I am trying to create a Fire Roll Call that lists current employees when they are classed as present.
When you look at the Present Employees screen in IFS the view is COMPANY_PERS_ASSIGN_BASIC. The Present column calls the following API to get the result of whether they are present or not:
Time_Pers_Diary_Clock_Util_Api.Is_Present_Offset(company_id, emp_no,null )
and returns a 1 or 0.
This was working fine in my Crystal Report but is not available when you add the WEB_UTIL_API. I have tried adding it as a custom field within the COMPANY_PERS_ASSIGN_BASIC view but cannot seem to get this to work.
How can I get the result of the API into my report?
Any advice gratefully received.