on 07-03-2019 1:42 PM
Hi Friends,
Could you please help us with the below request:
We have a requirement where we need to run the effective/periodic delta date query dynamically from successfactor without doing any mapping (pass through ) 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-07-01T01:00:00Z') AND fromDate = to_date('2019-07-05','yyyy-MM-dd') AND toDate = to_date('2019-07-09','yyyy-MM-dd'))
For this query, we will need to dynamically change the WHERE clause as follows
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.
User | Count |
---|---|
84 | |
10 | |
10 | |
9 | |
7 | |
6 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.