XSLT to create filtered subset

John Bailo wrote:

Given this XML:

<?xml version="1.0" encoding="UTF-8"?>
<pallet>
<position row="0" bay="0" level="A">
<client id="ABC"></client>
</position>
<position row="1" bay="1" level="B">
<client id="DEF"></client>
</position>
<position row="1" bay="1" level="C">
<client id="GHI"></client>
</position>
</pallet>

I want to return a subset,

<pallet>
<position row="0" bay="0" level="A">
<client id="ABC"></client>
</position>
</pallet>
But I can't seem to extend my stylesheet to something 3 nodes deep.

This:

<?xml version="1.0" encoding="UTF-8"?>
<xsl:styleshe et version="1.0"
xmlns:xsl="http ://www.w3.org/1999/XSL/Transform">
<xsl:output method="xml"/>
<xsl:template match="/">
<pallet>
<xsl:apply-templates select="pallet/position"/>
</pallet>
</xsl:template>
<xsl:template match="pallet">
<xsl:apply-templates/>
</xsl:template>
<xsl:template match="position[@row=0]">
<position>
<xsl:attribut e name="row">
<xsl:value-of select="@row"/>
</xsl:attribute>
<xsl:attribut e name="bay">
<xsl:value-of select="@bay"/>
</xsl:attribute>
<xsl:attribut e name="level">
<xsl:value-of select="@level"/>
</xsl:attribute>
</position>
<xsl:apply-templates/>
</xsl:template>
</xsl:stylesheet>

will return

<?xml version="1.0" encoding="UTF-16"?>
<pallet>
<position row="0" bay="0" level="A" />
</pallet>
But say I want to extend it to return:

<?xml version="1.0" encoding="UTF-16"?>
<pallet>
<position row="0" bay="0" level="A" />
<client id="ABC">
</client>
</pallet>

How do I do that?

--
() ASCII Ribbon Campaign | Joe Kesselman
/\ Stamp out HTML e-mail! | System architexture and kinetic poetry

Jun 12 '06 #2

The complicating factor here is that you want to pull <client> out of
<position>. That means you need to independently match on "the client
which is within the position with row='0'".

Maintaining your somewhat verbose style:

<xsl:template match="client[../position[@row='0']"
<client>
<xsl:attribut e name="id">
<xsl:value-of select="@id"/>
</xsl:attribute>

</client>
</xsl:template/>

If you haven't already done so, you really want to look at the xsl:copy
and xsl:copy-of directives, and at the standard "identity transformation
with exceptions" approachh; those techniques would make this partcular
example significantly cleaner, unless you have a Good Reason for doing
everything explicitly.
--
() ASCII Ribbon Campaign | Joe Kesselman
/\ Stamp out HTML e-mail! | System architexture and kinetic poetry

Jun 12 '06 #3

Sorry, forgot to say that you also need to modify:

<xsl:template match="pallet">
<xsl:apply-templates select="positio n"/>
<xsl:apply-templates select="positio n/client"/>
</xsl:template>

Actually, performance would probably be better if you changed that to

<xsl:template match="pallet">
<xsl:apply-templates select="positio n[@row=0]"/>
<xsl:apply-templates select="positio n[@row=0]/client"/>
</xsl:template>

You could then consider removing the predicates from the templates for
position and client.
--
() ASCII Ribbon Campaign | Joe Kesselman
/\ Stamp out HTML e-mail! | System architexture and kinetic poetry

Jun 12 '06 #4

John Bailo

Joe Kesselman wrote:

You could then consider removing the predicates from the templates for
position and client.

I am still having trouble. I changed the xslt to this. I think it
should produce an exact replica of the original XML:

<?xml version="1.0" encoding="UTF-8"?>
<xsl:styleshe et version="1.0"
xmlns:xsl="http ://www.w3.org/1999/XSL/Transform">
<xsl:output method="xml"/>

<xsl:template match="/">
<pallet>
<xsl:apply-templates select="pallet/position"/>
</pallet>
</xsl:template>

<xsl:template match="pallet">

<xsl:apply-templates select="positio n"/>
<xsl:apply-templates select="positio n/client"/>

<xsl:apply-templates/>
</xsl:template>

<xsl:template match="position ">
<position>
<xsl:attribut e name="row">
<xsl:value-of select="@row"/>
</xsl:attribute>
<xsl:attribut e name="bay">
<xsl:value-of select="@bay"/>
</xsl:attribute>
<xsl:attribut e name="level">
<xsl:value-of select="@level"/>
</xsl:attribute>
</position>
<xsl:apply-templates/>
</xsl:template>


<xsl:template match="client[../position]">
<client>
<xsl:attribut e name="id">
<xsl:value-of select="@id"/>
</xsl:attribute>

</client>
</xsl:template>


</xsl:stylesheet>
And the result is:

<?xml version="1.0" encoding="UTF-16"?>
<pallet>
<position row="0" bay="0" level="A" />
<position row="1" bay="1" level="B" />
<position row="1" bay="1" level="C" />
</pallet>
Instead of

<?xml version="1.0" encoding="UTF-8"?>
<pallet>
<position row="0" bay="0" level="A">
<client id="ABC"></client>
</position>
<position row="1" bay="1" level="B">
<client id="DEF"></client>
</position>
<position row="1" bay="1" level="C">
<client id="GHI"></client>
</position>
</pallet>

Jun 12 '06 #5

John Bailo

Ok, I think I got it -- thanks for all your help!
You're second suggestion gave me the clues.

I also will try your optimizations -- you've opened my eyes as far as
the potential elegance of this language.
Here's my stylesheet:

<?xml version="1.0" encoding="UTF-8"?>
<xsl:styleshe et version="1.0"
xmlns:xsl="http ://www.w3.org/1999/XSL/Transform">
<xsl:output method="xml"/>

<xsl:template match="/">
<pallet>
<xsl:apply-templates select="pallet/position"/>
</pallet>
</xsl:template>

<xsl:template match="pallet">
<xsl:apply-templates select="positio n"/>
<xsl:apply-templates select="positio n/client"/>

</xsl:template>

<xsl:template match="position ">
<position>
<xsl:attribut e name="row">
<xsl:value-of select="@row"/>
</xsl:attribute>
<xsl:attribut e name="bay">
<xsl:value-of select="@bay"/>
</xsl:attribute>
<xsl:attribut e name="level">
<xsl:value-of select="@level"/>
</xsl:attribute>
<xsl:apply-templates select="client"/>
</position>

</xsl:template>
<xsl:template match="client">
<client>
<xsl:attribut e name="id">
<xsl:value-of select="@id"/>
</xsl:attribute>

</client>

</xsl:template>

</xsl:stylesheet>

John Bailo wrote:

Joe Kesselman wrote:
You could then consider removing the predicates from the templates for
position and client.

I am still having trouble. I changed the xslt to this. I think it
should produce an exact replica of the original XML:

<?xml version="1.0" encoding="UTF-8"?>
<xsl:styleshe et version="1.0"
xmlns:xsl="http ://www.w3.org/1999/XSL/Transform">
<xsl:output method="xml"/>

<xsl:template match="/">
<pallet>
<xsl:apply-templates select="pallet/position"/>
</pallet>
</xsl:template>

<xsl:template match="pallet">

<xsl:apply-templates select="positio n"/>
<xsl:apply-templates select="positio n/client"/>

<xsl:apply-templates/>
</xsl:template>

<xsl:template match="position ">
<position>
<xsl:attribut e name="row">
<xsl:value-of select="@row"/>
</xsl:attribute>
<xsl:attribut e name="bay">
<xsl:value-of select="@bay"/>
</xsl:attribute>
<xsl:attribut e name="level">
<xsl:value-of select="@level"/>
</xsl:attribute>
</position>
<xsl:apply-templates/>
</xsl:template>


<xsl:template match="client[../position]">
<client>
<xsl:attribut e name="id">
<xsl:value-of select="@id"/>
</xsl:attribute>

</client>
</xsl:template>


</xsl:stylesheet>
And the result is:

<?xml version="1.0" encoding="UTF-16"?>
<pallet>
<position row="0" bay="0" level="A" />
<position row="1" bay="1" level="B" />
<position row="1" bay="1" level="C" />
</pallet>
Instead of

<?xml version="1.0" encoding="UTF-8"?>
<pallet>
<position row="0" bay="0" level="A">
<client id="ABC"></client>
</position>
<position row="1" bay="1" level="B">
<client id="DEF"></client>
</position>
<position row="1" bay="1" level="C">
<client id="GHI"></client>
</position>
</pallet>

Jun 12 '06 #6

Simple (?) output of attributes with XSLT does not work

John Bailo wrote:

Actually, let's make that cleaner in several ways

<xsl:template match="pallet"> <xsl:for-each select="positio n[@row='0']">
<xsl:apply-templates select="."/>
<xsl:apply-templates select="client"/>
</xsl:for-each> </xsl:template> .... <xsl:template match="position "> .... <xsl:template match="client">

Let pallet handle selecting which descendents you care about, then just
provide templates for how to render them once selected.
--
() ASCII Ribbon Campaign | Joe Kesselman
/\ Stamp out HTML e-mail! | System architexture and kinetic poetry

Jun 12 '06 #7

Similar topics

1674

by: Harry Zoroc | last post by:

I would like to treat an xsd Schema file as XML file and to display the targetNamespace and all the imports. That's it. But the following does not work. Why? I did not enter the stylesheet in the xsd file directly but tried to compute the output on the command line e.g. with xalan like: java net.sf.saxon.Transform -o myout.html myschema.xsd myxsltfile.xslt Using Saxon yields no better result. The produced myout.html contains all HTML...

giving access on a subset of data filtered by user login?

1138

by: Massimiliano | last post by:

Hi all, I created a database application, and created the protection setup, with users and grants. I have this problem: I would like to filter/give access & grants on a particular subset of data, on the basis of the user logged in. In other words, say you have a table with a field containing a value, I would like a particular user who logs in to see modify and delete only his own data subset,

Subtracting the values in attributes in an XSLT

8969

by: David S. Alexander | last post by:

How can I do simple subtraction in an XSLT. I want to read a few attribute values from an XML document, calculate their difference, and transform that value to an attribute in the XML output document. My original XML is, <Dates> <Birth Year="1966" />

Looking for suggestions (xslt?) on stripping specified elements/attributesfrom XHTML

1272

by: Foxpointe | last post by:

Given some arbitrary XHTML, I'd like to obtain a 'simplified' XHTML result which strips out a large subset of standard elements and attributes - but not all. The main things I would like to accomplish: 1) Provide a list of elements/attributes to be stripped (i.e. everything else should be passed through) or those that should be passed through (i.e. everything else should be stripped) which would be applied recursively. 2) If an element...

Report the current filtered records from a Form

3460

by: melnhed | last post by:

---Report the current filtered records from a Form--- Hello All, I've seen this topic discussed before, but the solution described then doesn't work in my particular case. My Config: Access 2002 front-end using SQL Server 2000 (MSDE actually) via ADP/ADE Access Data Project.

3780

XSLT for WSDL reduction

by: Scott Sauyet | last post by:

I'm trying to select a subset of a WSDL document using XSLT and a simple text document describing the high-level elements to include. I have it working fine for selecting the services, bindings, portTypes, and messages to use. But I'm stumped on how to get the xs:simpleType and xs:complexType elements filtered properly. I am not trying to do this in a generic way. The WSDL is generated by a tool in our backend system, and I know a fair...

xslt parsing xml data with '<' invalid character

3812

by: qbp90x5lb | last post by:

I'm using an XSLT transform to output the element value contents from a simple XML file into a new .TXT file. Everything works fine except for certain XML files, when calling msxsl with the .xslt, I get the following error: Code: 0xc00ce504 File: ...... Line: ... Column: ... A name was started with an invalid character. The error refers to the '<' found in the string "<20" from my example xml file below (a).

XML

1581

Create table based on records in filtered form

by: ramseyscripts | last post by:

I have Table A that is displayed through a form. Table A can be filtered through the form to create a subset of Table A records. How can I create a new table, Table B, with only the records in the filtered subset of Table A?

XSLT - Extracting name-value pairs

4558

by: Ebenezer | last post by:

Let's suppose I have some nodes in an XML file, with an URL attribute: <node url="mypage.php?name1=value1&foo=bar&foo2=bar2&name2=value0" /> <node url="myotherpage.php?name4=value4&foo=bar3&foo2=bar5&name2=value8" /> and so on. Let's suppose I want to retrieve this @url parameter, BUT ONLY with the values, in querystring, associated with "foo" and "foo2" (thus discarding name1, name2, name4 and every other different ones).

Changing the language in Windows 10

8609

by: Hystou | last post by:

Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...

Windows Server

9170

Problem With Comparison Operator <=> in G++

by: Oralloy | last post by:

Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...

C / C++

9031

Maximizing Business Potential: The Nexus of Website Design and Digital Marketing

by: jinu1996 | last post by:

In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth. The Art of Business Website Design Your website is...

Online Marketing

8901

The easy way to turn off automatic updates for Windows 10/11

by: Hystou | last post by:

Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...

Windows Server

6528

Access Europe - Using VBA to create a class based on a table - Wed 1 May

by: isladogs | last post by:

The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...