on 11-07-2018 8:10 AM
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
Hello Venkata,
I dont see last_modified_on in your query.
Could you please check below KBA which might help you.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
One quick note is Employment is not effective dated segment. Job and Comp which are under Employment are effective dated.
-Bhargav
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
any updates here
why can we not filter future dates records in query?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
101 | |
13 | |
13 | |
11 | |
11 | |
7 | |
6 | |
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.