on 04-06-2016 8:56 AM
Hello everyone,
let's say we have following node structure :
/compoundemployee/person/employment_information -> 0:1 records
custom_string1
end_date
start_date
user_id
...
/compoundemployee/person/personal_information -> 0:n records
end_date
start_date
....
Question:
For selection of personal_information, personal_information/start_date needs to be >= employment_information/start_date <= personal_information/end_date.
I tried the mapping below, but for attached test data I get for person_id 2714 the personal_information from 2810. For 2810 I get the personal_information from 2830. There seems to be some context issue, but can't exactly point out why.
The personal_information/end_date value can be null, so I have added 'mapWithDefault'. To keep the queue consistent, I have added 'mapWithDefault' to personal_information in 'useOneAsMany', as i.e person_id 20 has no personal_information.
The context of employment_information/start_date below is changed to /person, this is a 0:1.
Test data attached :
Any clue?
Thanks again, appreciated -
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Praveen,
thanks for the suggestion. I tried the mapping, but still end up with 'Brad Pitt' for person_id 2710 as in the screenshot earlier.
Context of /queryCompoundEmployeeResponse/CompoundEmployee/person/employment_information/start_date is also set to person.
Thanks again & best regards,
Kevin
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
90 | |
10 | |
10 | |
10 | |
7 | |
7 | |
6 | |
5 | |
4 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.