Home » Developer & Programmer » JDeveloper, Java & XML » XML Document Formatting (LINUX)
XML Document Formatting [message #339518] Thu, 07 August 2008 14:17 Go to next message
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
Re: XML Document Formatting [message #339522 is a reply to message #339518] Thu, 07 August 2008 14:47 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
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
Re: XML Document Formatting [message #340856 is a reply to message #339518] Thu, 14 August 2008 11:54 Go to previous message
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
Previous Topic: XML format question
Next Topic: OA Page Error
Goto Forum:
  


Current Time: Thu Mar 28 18:09:35 CDT 2024