Of course you'll have to iterate over each document in the database, but
here's how you can format each document:
xquery version "1.0-ml";
let $doc := document {
<results>
<name>Test</name>
<date>01-Oct-2009</date>
<interface>
<id>ID 1</id>
<address>2345</address>
</interface>
<interface>
<id>ID 2</id>
<address>3456</address>
</interface>
<interface>
<id>ID 3</id>
<address>6789</address>
</interface>
<interface>
<id>ID 4</id>
<address>7890</address>
</interface>
</results>
}
let $name := $doc/results/name
let $date := $doc/results/date
return element item {
for $if in $doc/results/interface
return element if {
element name {$name},
element date {$date},
element id {$if/id},
element address {$if/address}
}
}
Tim Meagher - AAOM Consulting
_____
From: [email protected]
[mailto:[email protected]] On Behalf Of Tony Mariella
Sent: Thursday, October 01, 2009 10:03 AM
To: [email protected]
Subject: [MarkLogic Dev General] Format XML Results
I have a query in Marklogic that returns results.
The query works fine. But I need to format the results so that I can out
them into a table.
Here's what each document looks like when it is loaded into ML:
<results>
<name>Test</name>
<date>01-Oct-2009</date>
<interface>
<id>ID 1</id>
<address>2345</address>
</interface>
<interface>
<id>ID 2</id>
<address>3456</address>
</interface>
<interface>
<id>ID 3</id>
<address>6789</address>
</interface>
<interface>
<id>ID 4</id>
<address>7890</address>
</interface>
</results>
Here's what I want tthe output to look like when I return it from my query:
<item>
<if>
<name>Test</name>
<date>01-Oct-2009</date>
<id>ID 1</id>
<address>2345</address>
</if>
<if>
<name>Test</name>
<date>01-Oct-2009</date>
<id>ID 2</id>
<address>3456</address>
</if>
<if>
<name>Test</name>
<date>01-Oct-2009</date>
<id>ID 3</id>
<address>6789</address>
</if>
<if>
<name>Test</name>
<date>01-Oct-2009</date>
<id>ID 4</id>
<address>7890</address>
</if>
</item>
How can I format the output correctly ?
Tony Mariella
_______________________________________________
General mailing list
[email protected]
http://xqzone.com/mailman/listinfo/general
