PI / HCI mapping question

[former_member207428]

Hello everyone,

and another question : let's say we have following node structure :

/compoundemployee/person/employment_information -> 0:1 records

    custom_string1

    end_date

    start_date

    user_id

    ...

    job_information -> 0:n records

      end_date

      start_date

      emplStatus

      ....

Question:

job_information needs to be selected where the start_date >= /compoundemployee/person/employment_information/start_date <= end_date, and emplStatus = 'A'.

I tried the mapping below, as soon as there is for one of the records no job_information node in the data, the next outputs are incorrect and don't show any job_information data eiter.

Sample data that is causing the issue is attached, as well as the XSD file.

Any suggestions?

Thanks again !

joiners.xsd.txt.zip

[former_member182412 · Accepted solution]

Hi Kevin,

Use below mapping all the fields context should be employment_information.

Regards,

Praveen.

[former_member207428 · Accepted solution]

Hi Praveen,

thanks again - I have tried your mapping (with the sample data), but get an exception.

Field mapped to useOneAsMany is the /compoundemployee/person/employment_information/job_information/start_date.

Context of all other fields is set to employment_information.

[former_member182412 · Accepted solution]

Hi Kevin,

The start_date to useOneAsMany is form employment_information not from job_information.

All other start_date fields are from job_information.

Regards,

Praveen.

[former_member207428 · Accepted solution]

Hi Praveen,

yes, got it working now - very clever, once again.

If I wish to use the same /compoundemployee/person/employment_information/start_date (employment_information node is 0...1), in a lower subnode, say

/compoundemployee/person/employment_information/job_information/FOCompany, can I apply the same logic ? I seem to be struggling here.

[former_member207428 · Accepted solution]

Seems like your original image went missing.