Future dated termination filtered in Query

[former_member75481]

Dear community users,

I have faced the CompoundEmployee API limitation that (according to SAP delta documentation) I see no way how to use a filter inside the query to extract the termination only effective on today. I tried to use Period delta (fromDate .... to date) or Effective end date params but still all records are passed.

I would kindly ask you for help me and assure that it is or is not possible.

Following use case:

I need to send terminations effective from past to today (client does not accept future terminations) in delta mode (so only changes are send).

If I will use filters inside iflow but not in query - all filtered delta changes will be lost after one run.

Interface is scheduled once/day.

query:

SELECT person, employment_information, job_information, national_id_card, personal_information FROM CompoundEmployee WHERE last_modified_on > to_datetime('${property.maxDateFromLastRun1}') AND company_territory_code = 'TUR' AND fromDate = to_date('${property.currentDate}','YYYY-MM-DD') AND toDate = to_date('${property.currentDate}','YYYY-MM-DD')

test case:

- 2 records - termination date = yesterday

- 2 records - termination date = today

- 2 records - termination date = tomorrow

expected output:

-send only those terminations effective today

current output:

- all 6 records are propagated