OSB Xquery mapping from multiple to single by separating its value(s).
Hi,
I have one requirement in OSB, can some one explain the implementation for this:
I have one element which is of type unbound. I need to map this element to a single element and to append all the element values by separating each element value with a ';' before that I need to check whether this element(s) are present in the request then need to appened all these element values to a single element and at the end of this element need to append default values.
Scenario:
<student>
<name>asd</name>
<address>
<street>street1</street>
<street>street2</street>
<street>street3</street>
||
||
</address>
to be mapped it to:
<student>
<field name="NAME">asd</field>
<field name="ADDRESS">street1;street2;street3;default1;default2;default3</field>
</student>
Here need to check if street names are present in the request xml, if yes ned to assign it to ADDRESS as mentioned above whether street names present or not need to append the default values at the end to the ADDRESS field like
<field name="ADDRESS">default1;default2;default3</field>
Thanks in advance.