SAP Cloud platform integration CPI\HCI Future dated data is appearing with fitter period delta

[Former Member]

Below query we are using

SELECT person, address_information, dependent_information, email_information, emergency_contact_primary, employment_information, compensation_information, paycompensation_recurring, deduction_recurring, global_assignment_information, job_information, paycompensation_non_recurring, payment_information, national_id_card, personal_information, phone_information FROM CompoundEmployee WHERE company = '"+ CompanyCo +"' and compensation_pay_group = '"+ PayGroupID +"' and to_datetime('2018-11-06T01:30:00Z') and fromDate = to_date('2018-11-01','yyyy-MM-dd') and toDate = to_date('2018-11-15','yyyy-MM-dd')</urn:queryString>ORDER BY start_date DESC

Employment information is appearing for future dated employee which getting hired on 19th November it should not appear and please provide suggestion any filter condition

[Sriprasadsbhat · Accepted solution]

Hello Venkata,

I dont see last_modified_on in your query.

Could you please check below KBA which might help you.

2649816

[Former Member · Accepted solution]

hi sriprasad,

thanks for quick answer

Below mentioned query deatils

SELECT person, address_information, dependent_information, email_information, emergency_contact_primary, employment_information, compensation_information, paycompensation_recurring, deduction_recurring, global_assignment_information, job_information, paycompensation_non_recurring, payment_information, national_id_card, personal_information, phone_information FROM CompoundEmployee WHERE company = '"+ CompanyCo +"' and compensation_pay_group = '"+ PayGroupID +"' and last_modified_on > to_datetime('2018-11-06T01:30:00Z') and fromDate = to_date('2018-11-01','yyyy-MM-dd') and toDate = to_date('2018-11-15','yyyy-MM-dd') ORDER BY start_date DESC

[former_member26700]

One quick note is Employment is not effective dated segment. Job and Comp which are under Employment are effective dated.

-Bhargav

[former_member75481]

any updates here
why can we not filter future dates records in query?

[Former Member]

SELECT person, address_information, dependent_information, email_information, emergency_contact_primary, employment_information, compensation_information, paycompensation_recurring, deduction_recurring, global_assignment_information, job_information, paycompensation_non_recurring, payment_information, national_id_card, personal_information, phone_information FROM CompoundEmployee WHERE company = '"+ CompanyCo +"' and compensation_pay_group = '"+ PayGroupID +"' and last_modified_on > to_datetime('2018-11-06T01:30:00Z') and fromDate = to_date('2018-11-01','yyyy-MM-dd') and toDate = to_date('2018-11-15','yyyy-MM-dd') ORDER BY start_date DESC