How to update sender SFSF channel with Dynamic periodic delta date query

[former_member617617]

Hi Friends,

Could you please help us with the below request:

We have a requirement where we need to run the effective delta date query Dynamically from successfactor.

Currently we are using the static Query where we are changing the date every time when we run the interface for the required information.

SELECT person, personal_information, address_information, employment_information, job_information, national_id_card, email_information FROM CompoundEmployee WHERE (last_modified_on > to_datetime('2019-06-15T01:00:00Z') AND fromDate = to_date('2019-06-30','yyyy-MM-dd') AND toDate = to_date('2019-07-02','yyyy-MM-dd'))

• For this query, we will need to dynamically change the WHERE clause as follows

• Last_modified_on > to_datetime(‘yyyy-mm-ddT01:00:00Z’) should be today minus 1. For example, today, 6/19/2019, we will enter the WHERE as “last_modified_on > to_datetime(‘2019-06-18T01:00:00Z’)”. Tomorrow, 6/20/2019, we will need to update the query parameter to be “last_modified_on > to_datetime(‘2019-06-19T01:00:00Z’)”.
• fromDate = to_date(‘yyyy-mm-dd’,’yyyy-mm-dd’) should be today. For example, today we will send fromDate= to_date(‘2019-06-19,’yyyy-mm-dd’). Tomorrow we will send fromDate= to_date(‘2019-06-20,’yyyy-mm-dd’)
• toDate= to_date(‘yyyy-mm-dd’,’yyyy-mm-dd’) should be today. For example, today we will send toDate= to_date(‘2019-06-19,’yyyy-mm-dd’). Tomorrow we will send toDate= to_date(‘2019-06-20,’yyyy-mm-dd’)

I have gone through the below blogs but didn't get the accurate result.

https://apps.support.sap.com/sap/support/knowledge/public/en/2528499

https://answers.sap.com/questions/68199/how-to-update-sender-sfsf-channel-with-dynamic-dat.html

Please help me if you have any suggestions.

Thank you.