SSDN - Grouping in xQurey (Nested For command)

XML Editor

Sign Up

Search

Options

Chat

Help

News

Log in

Not Logged in

Conferences

	Stylus Studio Feature Requests (1192)
	Stylus Studio Technical Forum (14621)
	Website Feedback (249)
	XSLT Help and Discussion (7625)
	XQuery Help and Discussion (2017)
	Issue with Processing Instruct... (2)
	problem converting json to XML... (2)
	Problem base64 decoding string... (3)
	Problems posting multipart for... (5)
	trouble with download of price... (2)
	Problem with http-post not bei... (3)
	path problem, xps_file:writeAl... (9)
	Xquery update support? (2)
	problem with Stylus studio try... (5)
	adding dtd reference to xml ou... (4)
	xquery escaping ambarsand when... (3)
	Whitespace problem when return... (5)
	Problem with namespace prefix ... (5)
	Sending via SFTP returns unexp... (1)
	Query and Sftp clent (4)
	xquery and try - catch (3)
	Query + ddtek:http-post optio... (5)
	Example files referenced in do... (3)
	Automatic Error Detection and ... (3)
	Working with result of ddtek:h... (2)
	[1-20] [21-40] [41-60] Next
	Stylus Studio FAQs (159)
	Stylus Studio Code Samples & Utilities (364)
	Stylus Studio Announcements (113)

Topic

Julio de la Vega

Subject: Grouping in xQurey (Nested For command)
Author: Julio de la Vega
Date: 18 Dec 2007 10:13 AM

Hi *,

I have a little problem with my xQuery development.
My input xml is:

<10>
<Field1>xxxx</Field1>
<Field2>xxxx</Field2>
<Field3>xxxx</Field3>
</10>

<20>
<Field1>xxxx</Field1>
<Field2>xxxx</Field2>
</20>

<20>
<Field1>xxxx</Field1>
<Field2>xxxx</Field2>
</20>

<10>
<Field1>xxxx</Field1>
<Field2>xxxx</Field2>
<Field3>xxxx</Field3>
</10>

<20>
<Field1>xxxx</Field1>
<Field2>xxxx</Field2>
</20>

Records type '20' can appear n times.

I need to change my xml to group records type 20 as children of their previous record type 10:

<10>

<20>

<20>

</10>

<10>

<20>

</10>

…

My xQuery development is getting all records type 20 together per every record 10. Could you please help me to understand why? I need to group the records type 20 with is records type 10.

This is my actual development

let $doc := doc('converter:file:///\\Server-hps\tecnico\Proyectos\Caja Madrid\Xpresso\Stylus\Desarrollos\SICAV\XQUERY\SICAVXQUERY.conv?file:///\\Server-hps\tecnico\Proyectos\Caja Madrid\Xpresso\Stylus\Desarrollos\SICAV\XQUERY\SICAVXQUERYReducido.txt')
return
<root>
{
for $REG_10 in $doc/root/REG_10

return
<REG_10>
{$REG_10}
{
for $REG_20 in $doc/root/REG_20

return
<Datos>
{$REG_20}
</Datos>
}
</REG_10>
}
</root>

Thanks in advance

Regards

Minollo I.

Subject: Grouping in xQurey (Nested For command)
Author: Minollo I.
Date: 18 Dec 2007 11:42 AM

The easiest way to do this is probably to leverage the "<<" and ">>" XPath operators; you can change your code into something like the following (note the "where" condition on the second "for"):

let $doc := doc(...)
return
<root>
{
for $REG_10 at $REG_10-startPos in $doc/root/REG_10
return
<REG_10>
{$REG_10}
{
for $REG_20 at $REG_20-pos in $doc/root/REG_20
where $REG_20 >> $REG_10 and (empty($REG_10/following-sibling::REG_10) or ($REG_20 << $REG_10/following-sibling::REG_10[1]))
return
<Datos>
{$REG_20}
</Datos>
}
</REG_10>
}

</root>

Julio de la Vega

Subject: Grouping in xQurey (Nested For command)
Author: Julio de la Vega
Date: 18 Dec 2007 12:00 PM

Thank you, it works and does what I need.
My problem now is to undertand what you have done because I have to apply it in other parts of my development. Where can I find information about the commands you have used? Could you please 'tanslate' it and give me an overview?

Thanks in advance

Minollo I.

Subject: Grouping in xQurey (Nested For command)
Author: Minollo I.
Date: 18 Dec 2007 12:32 PM

Read the "where" condition:
where $REG_20 >> $REG_10 and (empty($REG_10/following-sibling::REG_10) or ($REG_20 << $REG_10/following-sibling::REG_10[1]))

It's saying: consider only those $REG_20's that follow $REG_10 in document order (the ">>" operator - http://www.w3.org/TR/xpath20/#id-node-comparisons), and that appear before (the "<<" operator) in document order relative to the next REG_10 node (retrieved using the followin-sibling axis - http://www.w3.org/TR/xpath20/#axes); the empty(...) expression only checks the special case when there are no further REG_10 elements, at the end of the document.

Julio de la Vega

Subject: Grouping in xQurey (Nested For command)
Author: Julio de la Vega
Date: 19 Dec 2007 02:33 AM

Thank you Minollo,

I will review the information you have sent to me

Thanks again

Julio de la Vega

Subject: Grouping in xQuery (Nested For command)
Author: Julio de la Vega
Date: 19 Dec 2007 07:10 AM

Hi again,

According to the same issue, now I need to do a secong grouping inside the first grouping. I need to group the records type 20 acording one of its children (the criteria for secod grouping is one of the children of 20)

This is the layout that I need:

<10>
<group_20_1>
<20>...</20>
<20>...</20>
<20>...</20>
</group_20_1>

<group_20_2>
<20>...</20>
<20>...</20>
</group_20_2>
</10>

<10>
...

Could you please give me an overview about how to do it?

Thanks again

Regards

Minollo I.

Subject: Grouping in xQuery (Nested For command)
Author: Minollo I.
Date: 19 Dec 2007 08:59 AM

I'm assuming you have asked the same question here: http://www.stylusstudio.com/ssdn/default.asp?action=9&read=7264&fid=57#22779

Let's keep the conversation in a single place then.

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.