Skip to Main Content

DevOps, CI/CD and Automation

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

OSB Xquery mapping from multiple to single by separating its value(s).

user12679330May 7 2010 — edited May 11 2010
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.
This post has been answered by odie_63 on May 11 2010
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jun 8 2010
Added on May 7 2010
10 comments
3,633 views