Skip to Content
0
Jul 03, 2019 at 12:12 PM

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

68 Views Last edit Jul 15, 2019 at 07:20 AM 2 rev

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.