How filter data from XML to XML

This transformation:

<xsl:stylesheet version="1.0"
xmlns:xsl="http://www.w3.org/1999/XSL/Transform">
<xsl:output omit-xml-declaration="yes" indent="yes"/>
<xsl:strip-space elements="*"/>

<xsl:template match="ROOT">
<xsl:copy>
<xsl:apply-templates select="PRODUCTS-LIST"/>
</xsl:copy>
</xsl:template>

<xsl:template match="PRODUCTS-LIST">
<xsl:copy>
<xsl:apply-templates
select="CAT[@ID = /*/*/*/RULE/CAT/@ID]"/>
</xsl:copy>
</xsl:template>

<xsl:template match="CAT">
<xsl:copy-of select=
"PROD[@ID = /*/*/*/RULE/CAT
[@ID = current()/@ID]/PRO/@ID]"/>
</xsl:template>
</xsl:stylesheet>

when applied on your source.xml:

<ROOT>
<PAGE NAME="homepage" URL="HP.html">
<RULES>
<RULE>
<CAT ID="1">
<PRO ID="3"></PRO>
<PRO ID="6"></PRO>
</CAT>
<CAT ID="3">
<PRO ID="2"></PRO>
<PRO ID="10"></PRO>
</CAT>
</RULE>
</RULES>
</PAGE>
<PRODUCTS-LIST>
<CAT ID="1">
<PROD ID="12">
<NAME>Prod. name</NAME>
<DESC><![CDATA[ Html desc ]]></DESC>
</PROD>
<PROD ID="6">
<NAME>Prod. name</NAME>
<DESC><![CDATA[ Html desc ]]></DESC>
</PROD>
<PROD ID="3">
<NAME>Prod. name</NAME>
<DESC><![CDATA[ Html desc ]]></DESC>
</PROD>
</CAT>
<CAT ID="2">
<PROD ID="7">
<NAME>Prod. name</NAME>
<DESC><![CDATA[ Html desc ]]></DESC>
</PROD>
</CAT>
<CAT ID="3">
<PROD ID="10">
<NAME>Prod. name</NAME>
<DESC><![CDATA[ Html desc ]]></DESC>
</PROD>
<PROD ID="1">
<NAME>Prod. name</NAME>
<DESC><![CDATA[ Html desc ]]></DESC>
</PROD>
<PROD ID="2">
<NAME>Prod. name</NAME>
<DESC><![CDATA[ Html desc ]]></DESC>
</PROD>
</CAT>
</PRODUCTS-LIST>
</ROOT>

produces the wanted result:

<ROOT>
<PRODUCTS-LIST>
<PROD ID="6">
<NAME>Prod. name</NAME>
<DESC> Html desc </DESC>
</PROD>
<PROD ID="3">
<NAME>Prod. name</NAME>
<DESC> Html desc </DESC>
</PROD>
<PROD ID="10">
<NAME>Prod. name</NAME>
<DESC> Html desc </DESC>
</PROD>
<PROD ID="2">
<NAME>Prod. name</NAME>
<DESC> Html desc </DESC>
</PROD>
</PRODUCTS-LIST>
</ROOT>
=====
Cheers,

Dimitre Novatchev.
http://fxsl.sourceforge.net/ -- the home of FXSL

"Luca" <lu********@hotmail.com> wrote in message
news:50**************************@posting.google.c om...

Hello,

have a problem with this XML, I need XSLT to filter the products list
based on rules writes in RULE tag.

I need copy only CAT and PROD data in PRODUCTS-LIST that match CAT and
PROD ID's in RULE tag.

for ex:

================================================== ========================
<ROOT>
<PAGE NAME="homepage" URL="HP.html">
<RULES>
<RULE>
<CAT ID="1">
<PRO ID="3"></PRO>
<PRO ID="6"></PRO>
</CAT>
<CAT ID="3">
<PRO ID="2"></PRO>
<PRO ID="10"></PRO>
</CAT>
</RULE>
</RULES>
</PAGE>
<PRODUCTS-LIST>
<CAT ID="1">
<PROD ID="12">
<NAME>Prod. name</NAME>
<DESC><![CDATA[ Html desc ]]></DESC>
</PROD>
<PROD ID="6">
<NAME>Prod. name</NAME>
<DESC><![CDATA[ Html desc ]]></DESC>
</PROD>
<PROD ID="3">
<NAME>Prod. name</NAME>
<DESC><![CDATA[ Html desc ]]></DESC>
</PROD>
</CAT>
<CAT ID="2">
<PROD ID="7">
<NAME>Prod. name</NAME>
<DESC><![CDATA[ Html desc ]]></DESC>
</PROD>
</CAT>
<CAT ID="3">
<PROD ID="10">
<NAME>Prod. name</NAME>
<DESC><![CDATA[ Html desc ]]></DESC>
</PROD>
<PROD ID="1">
<NAME>Prod. name</NAME>
<DESC><![CDATA[ Html desc ]]></DESC>
</PROD>
<PROD ID="2">
<NAME>Prod. name</NAME>
<DESC><![CDATA[ Html desc ]]></DESC>
</PROD>
</CAT>
</PRODUCTS-LIST>
</ROOT>
================================================== ========================
the final result of XSLT trasf.

================================================== ========================
<ROOT>
<PRODUCTS-LIST>
<CAT ID="1">
<PROD ID="6">
<NAME>Prod. name</NAME>
<DESC><![CDATA[ Html desc ]]></DESC>
</PROD>
<PROD ID="3">
<NAME>Prod. name</NAME>
<DESC><![CDATA[ Html desc ]]></DESC>
</PROD>
</CAT>
<CAT ID="3">
<PROD ID="10">
<NAME>Prod. name</NAME>
<DESC><![CDATA[ Html desc ]]></DESC>
</PROD>
<PROD ID="2">
<NAME>Prod. name</NAME>
<DESC><![CDATA[ Html desc ]]></DESC>
</PROD>
</CAT>
</PRODUCTS-LIST>
</ROOT>

================================================== =======================

Can anybody help me?

Thanks for answers!
Luca

Jul 20 '05 #2

Thanks Dimitre,

very useful, last suggetstion
I need nest PRODUCTS-LISTS into each CAT tag:

<CAT ID="1">
<PROD ID="6">
<NAME>Prod. name</NAME>
<DESC><![CDATA[ Html desc ]]></DESC>
</PROD>



</CAT>
Thanks a lot for any Help!!!

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

Jul 20 '05 #3

I don't see any PRODUCTS-LISTS below??? Nor any nesting.
=====
Cheers,

Dimitre Novatchev.
http://fxsl.sourceforge.net/ -- the home of FXSL

"luca milan" <lu********@hotmail.com> wrote in message
news:3f*********************@news.frii.net...

Thanks Dimitre,

very useful, last suggetstion
I need nest PRODUCTS-LISTS into each CAT tag:

<CAT ID="1">
<PROD ID="6">
<NAME>Prod. name</NAME>
<DESC><![CDATA[ Html desc ]]></DESC>
</PROD>



</CAT>
Thanks a lot for any Help!!!

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

Jul 20 '05 #4

sorry Dimitre, simply add this:

<CAT ID="{@ID}">
<xsl:copy-of select="PROD[@ID = /*/*/*/RULE/CAT[@ID =
current()/@ID]/PRO/@ID]"/>
</CAT>

in CAT template...

Thanks a lot for any Help!!!

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

Jul 20 '05 #5

"luca milan" <lu********@hotmail.com> wrote in message
news:3f*********************@news.frii.net...

sorry Dimitre, simply add this:

<CAT ID="{@ID}">
<xsl:copy-of select="PROD[@ID = /*/*/*/RULE/CAT[@ID =
current()/@ID]/PRO/@ID]"/>
</CAT>

in CAT template...

Thanks a lot for any Help!!!

Yes, sure -- I did forget to copy the CAT element itself -- sorry, it's
almost midnight here.

=====
Cheers,

Dimitre Novatchev.
http://fxsl.sourceforge.net/ -- the home of FXSL

Jul 20 '05 #6

No problem Dimitre,

but I have a last question, if I add others rules

<RULE NAME="fisrt">
<CAT ID="13">
<PRO ID="17"></PRO>
<PRO ID="14"></PRO>
</CAT>
</RULE>
<RULE NAME="second">
<CAT ID="13">
<PRO ID="17"></PRO>
<PRO ID="14"></PRO>
</CAT>
</RULE>

and so... I need group by rules the procucts list, for ex:

<RULE NAME="first">
CAT and PROD markup... for related rule
</RULE>
<RULE NAME="second">
CAT and PROD markup... for related rule
</RULE>

I can do this... now try...

Thanks a lot for any Help!!!

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

Jul 20 '05 #7

"luca milan" <lu********@hotmail.com> wrote in message
news:3f*********************@news.frii.net...

No problem Dimitre,

but I have a last question, if I add others rules

<RULE NAME="fisrt">
<CAT ID="13">
<PRO ID="17"></PRO>
<PRO ID="14"></PRO>
</CAT>
</RULE>
<RULE NAME="second">
<CAT ID="13">
<PRO ID="17"></PRO>
<PRO ID="14"></PRO>
</CAT>
</RULE>

and so... I need group by rules the procucts list, for ex:

<RULE NAME="first">
CAT and PROD markup... for related rule
</RULE>
<RULE NAME="second">
CAT and PROD markup... for related rule
</RULE>

I can do this... now try...

Anything can be done, but you're again too cryptic in explaining what you
want and I do not understand it.

Please, get accustomed to always provide a complete (but minimal) example
with a good explanation. In all other cases people start guessing what you
actually mean and want.

=====
Cheers,

Dimitre Novatchev.
http://fxsl.sourceforge.net/ -- the home of FXSL

Jul 20 '05 #8

I add this xml, for ex:

================================================== ========
<ROOT>
<PAGE NAME="homepage" url="hp.html">
<RULES>
<RULE NAME="first">
<CAT id="1">
<PRO id="3"></PRO>
<PRO id="6"></PRO>
</CAT>
</RULE>
<RULE NAME="second">
<CAT id="3">
<PRO id="1"></PRO>
</CAT>
</RULE>
</RULES>
</PAGE>
<PRODUCTS-LIST>
<CAT id="1">
<PROD id="12">
<NAME>PROD. NAME</NAME>
<DESC><![CDATA[ Html DESC ]]></DESC>
</PROD>
<PROD id="6">
<NAME>PROD. NAME</NAME>
<DESC><![CDATA[ Html DESC ]]></DESC>
</PROD>
<PROD id="3">
<NAME>PROD. NAME</NAME>
<DESC><![CDATA[ Html DESC ]]></DESC>
</PROD>
</CAT>
<CAT id="2">
<PROD id="7">
<NAME>PROD. NAME</NAME>
<DESC><![CDATA[ Html DESC ]]></DESC>
</PROD>
</CAT>
<CAT id="3">
<PROD id="10">
<NAME>PROD. NAME</NAME>
<DESC><![CDATA[ Html DESC ]]></DESC>
</PROD>
<PROD id="1">
<NAME>PROD. NAME</NAME>
<DESC><![CDATA[ Html DESC ]]></DESC>
</PROD>
<PROD id="2">
<NAME>PROD. NAME</NAME>
<DESC><![CDATA[ Html DESC ]]></DESC>
</PROD>
</CAT>
</PRODUCTS-LIST>
</ROOT>
================================================== ========

desiderd result:

================================================== ========

<ROOT>
<PRODUCTS-LIST>
<RULE NAME="first">
<CAT id="1">
<PROD id="6">
<NAME>PROD. NAME</NAME>
<DESC><![CDATA[ Html DESC ]]></DESC>
</PROD>
<PROD id="3">
<NAME>PROD. NAME</NAME>
<DESC><![CDATA[ Html DESC ]]></DESC>
</PROD>
</CAT>
</RULE>
<RULE NAME="second">
<CAT id="3">
<PROD id="1">
<NAME>PROD. NAME</NAME>
<DESC><![CDATA[ Html DESC ]]></DESC>
</PROD>
</CAT>
</RULE>
</PRODUCTS-LIST>
</ROOT>

================================================== ========
Thanks a lot for any Help!!!

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

Jul 20 '05 #9

Here it is:

This transformation:

<xsl:stylesheet version="1.0"
xmlns:xsl="http://www.w3.org/1999/XSL/Transform"
xmlns:ext="http://exslt.org/common"
exclude-result-prefixes="ext"

<xsl:output omit-xml-declaration="yes" indent="yes"
cdata-section-elements="DESC"/>

<xsl:strip-space elements="*"/>

<xsl:template match="/">
<ROOT>
<PRODUCTS-LIST>
<xsl:apply-templates select="*/*/RULES"/>
</PRODUCTS-LIST>
</ROOT>
</xsl:template>

<xsl:template match="RULES">
<xsl:variable name="vOut">
<xsl:for-each select="RULE">
<RULE NAME="{@NAME}">
<xsl:for-each select="CAT">
<xsl:if test="/*/PRODUCTS-LIST/CAT
[@id = current()/@id]
[PROD[@id = current()/PRO/@id]]">
<CAT id="{@id}">
<xsl:copy-of select=
"/*/PRODUCTS-LIST/CAT
[@id = current()/@id]
/PROD
[@id = current()/PRO/@id]"/>
</CAT>
</xsl:if>
</xsl:for-each>
</RULE>
</xsl:for-each>
</xsl:variable>

<xsl:copy-of select="ext:node-set($vOut)/*[*]"/>
</xsl:template>
</xsl:stylesheet>
when applied on your source.xml:

<ROOT>
<PAGE NAME="homepage" url="hp.html">
<RULES>
<RULE NAME="first">
<CAT id="1">
<PRO id="3"></PRO>
<PRO id="6"></PRO>
</CAT>
</RULE>
<RULE NAME="second">
<CAT id="3">
<PRO id="1"></PRO>
</CAT>
</RULE>
</RULES>
</PAGE>
<PRODUCTS-LIST>
<CAT id="1">
<PROD id="12">
<NAME>PROD. NAME</NAME>
<DESC><![CDATA[ Html DESC ]]></DESC>
</PROD>
<PROD id="6">
<NAME>PROD. NAME</NAME>
<DESC><![CDATA[ Html DESC ]]></DESC>
</PROD>
<PROD id="3">
<NAME>PROD. NAME</NAME>
<DESC><![CDATA[ Html DESC ]]></DESC>
</PROD>
</CAT>
<CAT id="2">
<PROD id="7">
<NAME>PROD. NAME</NAME>
<DESC><![CDATA[ Html DESC ]]></DESC>
</PROD>
</CAT>
<CAT id="3">
<PROD id="10">
<NAME>PROD. NAME</NAME>
<DESC><![CDATA[ Html DESC ]]></DESC>
</PROD>
<PROD id="1">
<NAME>PROD. NAME</NAME>
<DESC><![CDATA[ Html DESC ]]></DESC>
</PROD>
<PROD id="2">
<NAME>PROD. NAME</NAME>
<DESC><![CDATA[ Html DESC ]]></DESC>
</PROD>
</CAT>
</PRODUCTS-LIST>
</ROOT>
produces the wanted result:

<ROOT>
<PRODUCTS-LIST>
<RULE NAME="first">
<CAT id="1">
<PROD id="6">
<NAME>PROD. NAME</NAME>
<DESC><![CDATA[ Html DESC ]]></DESC>
</PROD>
<PROD id="3">
<NAME>PROD. NAME</NAME>
<DESC><![CDATA[ Html DESC ]]></DESC>
</PROD>
</CAT>
</RULE>
<RULE NAME="second">
<CAT id="3">
<PROD id="1">
<NAME>PROD. NAME</NAME>
<DESC><![CDATA[ Html DESC ]]></DESC>
</PROD>
</CAT>
</RULE>
</PRODUCTS-LIST>
</ROOT>
=====
Cheers,

Dimitre Novatchev.
http://fxsl.sourceforge.net/ -- the home of FXSL

"luca milan" <lu********@hotmail.com> wrote in message
news:3f*********************@news.frii.net... I add this xml, for ex:

================================================== ========
<ROOT>
<PAGE NAME="homepage" url="hp.html">
<RULES>
<RULE NAME="first">
<CAT id="1">
<PRO id="3"></PRO>
<PRO id="6"></PRO>
</CAT>
</RULE>
<RULE NAME="second">
<CAT id="3">
<PRO id="1"></PRO>
</CAT>
</RULE>
</RULES>
</PAGE>
<PRODUCTS-LIST>
<CAT id="1">
<PROD id="12">
<NAME>PROD. NAME</NAME>
<DESC><![CDATA[ Html DESC ]]></DESC>
</PROD>
<PROD id="6">
<NAME>PROD. NAME</NAME>
<DESC><![CDATA[ Html DESC ]]></DESC>
</PROD>
<PROD id="3">
<NAME>PROD. NAME</NAME>
<DESC><![CDATA[ Html DESC ]]></DESC>
</PROD>
</CAT>
<CAT id="2">
<PROD id="7">
<NAME>PROD. NAME</NAME>
<DESC><![CDATA[ Html DESC ]]></DESC>
</PROD>
</CAT>
<CAT id="3">
<PROD id="10">
<NAME>PROD. NAME</NAME>
<DESC><![CDATA[ Html DESC ]]></DESC>
</PROD>
<PROD id="1">
<NAME>PROD. NAME</NAME>
<DESC><![CDATA[ Html DESC ]]></DESC>
</PROD>
<PROD id="2">
<NAME>PROD. NAME</NAME>
<DESC><![CDATA[ Html DESC ]]></DESC>
</PROD>
</CAT>
</PRODUCTS-LIST>
</ROOT>
================================================== ========

desiderd result:

================================================== ========

<ROOT>
<PRODUCTS-LIST>
<RULE NAME="first">
<CAT id="1">
<PROD id="6">
<NAME>PROD. NAME</NAME>
<DESC><![CDATA[ Html DESC ]]></DESC>
</PROD>
<PROD id="3">
<NAME>PROD. NAME</NAME>
<DESC><![CDATA[ Html DESC ]]></DESC>
</PROD>
</CAT>
</RULE>
<RULE NAME="second">
<CAT id="3">
<PROD id="1">
<NAME>PROD. NAME</NAME>
<DESC><![CDATA[ Html DESC ]]></DESC>
</PROD>
</CAT>
</RULE>
</PRODUCTS-LIST>
</ROOT>

================================================== ========
Thanks a lot for any Help!!!

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

Jul 20 '05 #10

Filter Form through sub-form values

Great!

Thx a lot Dimitre!

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

Jul 20 '05 #11

Similar topics

by: Robert Neville | last post by:

I would like to add filter functionality to my database whether through the Main form or the subform. This question may be rudimentary, yet I have not less experience with filtering data outside...

Problem with 'Filter By Form'

by: CSDunn | last post by:

Hello, I have a problem with field filtering between an Access 2000 Project form (the application is called CELDT), and the report that shows the results of the filter. Both the form and the...

Filter By Selection Issue

by: damjanu | last post by:

Hi All; I need little help. I have a datasheet form. I allow user to do 'filter by selection'. My form contains a column with values. As user changes selections, I want to calculate totals....

Me.filter failing

by: dick | last post by:

I am just trying to print/report the results of a "filter by selection" which is done by right-clicking a form, filling in values, and "applying the filter." I have searched the newsgroups, and...

Maxing out a filter string?

by: Salad | last post by:

I have a log file with a list of records. The log file can be unfiltered or filtered. I have a command button to call a data entry form from the log. At first I was only going to present the...

How do I refresh DataView filter efficiently

by: Vern | last post by:

The following code retrieves data into a dataset, and then creates a dataview with a filter. This dataview is then attached to a combobox. When the effective date changes, I would like to see the...

C# / C Sharp

How can you filter data in a Custom DropDownList....

by: RyanG | last post by:

when the value that determines the filter is databound?? I am trying to make a DropDownList for a set of data that I use a lot throughout my project. So I extended the DropDownList to retrieve...

ASP.NET

Alphabetical Filter Bar

by: chiinook | last post by:

I have been creating a contact management database which now has about 300 records in it. I've been filtering using the "filter by form" command but I'd like to automate this with a set of buttons...

Filter by form problem with Yes/No Data and SQL Server

VBA and Filter Question

by: Soulspike | last post by:

Form name to filter = frmSortFor Filter based on list box from frmTest= lstSortFor Form containing list box = frmTest Field (CompCodes) data format = "PM SM TS EW WA" I have a database that I...

Visual Basic 4 / 5 / 6

by: Jim Mandala | last post by:

Using Access 2003 front end; SQL Server 2005 Back end: I have a complex form that has lots of data fields including about thirty or so checkboxes storing Yes/No data that I would like my users...