OraFAQ Forum: JDeveloper, Java & XML » XML Document Formatting

Home » Developer & Programmer » JDeveloper, Java & XML » XML Document Formatting (LINUX)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

XML Document Formatting [message #339518]

Thu, 07 August 2008 14:17

jango
Messages: 2
Registered: March 2007

Junior Member

I am trying to create an XML doc that is fairly comlex. The final doc needs to look like the following:-

<?xml version="1.0"?>
<provider>
<provider-id>110078</provider-id>
<patient>
<first-name>BRITTANY</first-name>
<last-name>THOMAS</last-name>
<encounter measure-set="HOP-HYYS">
<encounter-date>05/31/2008</encounter-date>
<patient-HIC-Number>111745603216</patient-HIC-Number>
<patient-id>41987428</patient-id>
<medical-record-nbr>1673807</medical-record-nbr>
<detail answer-code="03" row-number="0" question-cd="TRGE" />
<detail answer-code="02" row-number="1" question-cd="TRGE" />
<detail answer-code="05" row-number="2" question-cd="TRGE" />
<detail answer-code="7766" row-number="0" question-cd="VHAT" />
<detail answer-code="00817" row-number="1" question-cd="LAOL" />
/encounter>
</patient>
<patient>
<first-name>DAVID</first-name>
<last-name>RABOTTE</last-name>
<encounter measure-set="HOP-HYYS"> <encounter-date>05/31/2008</encounter-date>
<patient-HIC-Number>111374011334</patient-HIC-Number>
<patient-id>44491968</patient-id>
<medical-record-nbr>1687914</medical-record-nbr>
<detail answer-code="01" row-number="0" question-cd="TRGE" />
<detail answer-code="07" row-number="1" question-cd="TRGE" />
<detail answer-code="35" row-number="1" question-cd="KUAH" />
<detail answer-code="7766" row-number="0" question-cd="VHAT" />
<detail answer-code="00822" row-number="1" question-cd="OTHIN" />
</encounter>
</patient>
</provider>

Can't show the query because it is huge. Am only interested in the <detail tags. How do you make it do that?

Thanks
Vish

Report message to a moderator

Re: XML Document Formatting [message #339522 is a reply to message #339518]

Thu, 07 August 2008 14:47

Michel Cadot
Messages: 68716
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

You are creating it from what?
And what is the question? How to make the xml?

Post a test case: create table and insert statements along with the result you want with these data.

Regards
Michel

Report message to a moderator

Re: XML Document Formatting [message #340856 is a reply to message #339518]

Thu, 14 August 2008 11:54

rakesh1024
Messages: 3
Registered: August 2008

Junior Member

From what I understand, you are creating an XML file through Report Builder.

All you have to do is double click on the elements you don't want to display in your data model and set "Exclude from XML Output" to 'Yes' Smile

Report message to a moderator

Previous Topic:	XML format question
Next Topic:	OA Page Error

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Nov 21 16:37:38 CST 2024