Skip to main content
Question

Filtering Issue with Special Characters in Employee Status – Apps 10 UPD 24

  • February 19, 2025
  • 1 reply
  • 20 views

Forum|alt.badge.img+5
  • Sidekick (Customer)
  • 15 replies

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!

 

 

 

 

1 reply

Forum|alt.badge.img+16
  • Superhero (Partner)
  • 398 replies
  • February 19, 2025

Hi

During session initialization the language is setting. So with this it might be problem that someone start using application with different language or any process is being launched with different language that it was previosly.


Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings