We are experiencing an issue in IFS Apps 10 Update 24 where filtering on the employee_status column is not returning expected results.
For example, the following query does not return any data:
SELECT t.employee_status, t.company_id, t.emp_no
FROM ifsapp.COMPANY_PERSON_ALL t
WHERE t.employee_status = 'Beëindigd';
However, when we select data without the filter, we can see that the column employee_status contains the value "Beëindigd", so the filter should return results but does not.
This issue started 2–3 days ago, and the query was working fine before. We suspect there might be a change in session parameters or how special characters are handled.
Has anyone else faced this issue in IFS Apps 10 UPD 24? Any insights or solutions would be appreciated.
Note: The same filter is working fine in IFS enterprise explorer SQL query tool and in Employee file screen also.
Thanks in advance!