SSDN - XQuery Format of XML code snippet

XML Editor

Sign Up

Search

Options

Chat

Help

News

Log in

Not Logged in

Topic

Topic Page 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20

Michael Nevins

Subject: XQuery Format of XML code snippet
Author: Michael Nevins
Date: 27 May 2010 01:53 PM

I do not seem to be able to return the same order I start with, can you please advise.

I need the <ForceData> element between the
<Data> element
**here** and the
<Data Format="Decorated"/>

I attached the xml file I started with and here is the query I am using?
*******************************************
<Connections>
{ /Connections/text() }
<Connection>
{ /Connections/Connection/text() }
<OutputTag>
{ /Connections/Connection/OutputTag/text() }
{
for $Data in /Connections/Connection/OutputTag/Data
return
if($Data/@Format = "Decorated") then
<Data Format="{ $Data/@Format }">
{ $Data/text() }
</Data>
else
<Data>
{ $Data/text() }
</Data>
}
<ForceData>
{ /Connections/Connection/OutputTag/ForceData/text() }
</ForceData>
</OutputTag>
</Connection>
</Connections>
******************************************************
Michael A. Nevins
Northrop Grumman
Electronic Systems

Connections.xml
Connections.xml

Michael Nevins

Subject: XQuery Format of XML code snippet
Author: Michael Nevins
Date: 27 May 2010 01:56 PM

trying to attach the file

Michael A. Nevins
Northrop Grumman
Electronic Systems

Connections(1).xml

Michael Nevins

Subject: XQuery Format of XML code snippet
Author: Michael Nevins
Date: 27 May 2010 01:58 PM

cant attach file, so here it is.

Thanks,
<?xml version="1.0"?>
<Connections xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:noNamespaceSchemaLocation="file:///c:/BaseLineThread/Modules/Connections/Connections.xsd">
<Connection Name="Standard" RPI="20000" Type="Output" EventID="0" ProgrammaticallySendEventTrigger="false">
<InputTag>
<ForceData>00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00
00 00 00 00 00 00 00 00</ForceData>
<Data Format="Decorated">
<Structure DataType="AB:1756_DO:I:0">
<DataValueMember Name="Fault" DataType="DINT" Radix="Binary" Value="2#0000_0000_0000_0000_0000_0000_0000_0000"/>
<DataValueMember Name="Data" DataType="DINT" Radix="Binary" Value="2#0000_0000_0000_0000_0000_0000_0000_0000"/>
</Structure>
</Data>
</InputTag>
<OutputTag>
<Data>00 00 00 00</Data>
<ForceData>00 00 00 00 00 00 00 00 00 00 00 00</ForceData>
<Data Format="Decorated">
<Structure DataType="AB:1756_DO:O:0">
<DataValueMember Name="Data" DataType="DINT" Radix="Binary" Value="2#0000_0000_0000_0000_0000_0000_0000_0000"/>
</Structure>
</Data>
</OutputTag>
</Connection>
</Connections>

Michael A. Nevins
Northrop Grumman
Electronic Systems

Minollo I.

Subject: XQuery Format of XML code snippet
Author: Minollo I.
Date: 27 May 2010 02:17 PM

I can see your attachment.

This is one way of doing what you are looking for; whether that's correct or not it depends on what the structure of the source and target XML documents are in general (and not just in this particular case):

<Connections>
{ /Connections/text() }
<Connection>
{ /Connections/Connection/text() }
<OutputTag>
{ /Connections/Connection/OutputTag/text() }
{
for $Data in /Connections/Connection/OutputTag/Data
return
if($Data/@Format = "Decorated") then
<Data Format="{ $Data/@Format }">
{ $Data/text() }
</Data>
else
(<Data>
{ $Data/text() }
</Data>,
<ForceData>
{ /Connections/Connection/OutputTag/ForceData/text() }
</ForceData>)
}
</OutputTag>
</Connection>
</Connections>

Topic Page 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20

Powered by Stylus Studio, the world's leading XML IDE for XML, XSLT, XQuery, XML Schema, DTD, XPath, WSDL, XHTML, SQL/XML, and XML Mapping!

Go to Conference:

Log In Options Username: Password:

Site Map | Privacy Policy | Terms of Use | Trademarks

Stylus Studio® and DataDirect XQuery ™are from DataDirect Technologies, is a registered trademark of Progress Software Corporation, in the U.S. and other countries. © 2004-2016 All Rights Reserved.