Blog E

To search a attribute via XPATH. you can use Element[@Attr] to address it in XPATH.

So~~ to search some specific search as follow:

1. product@cost which is > 5000, you can write as follow.

product[@cost > ‘5000′]

2. product@name contains "yellow" (case-insensitivity).

contains(translate(product[@name], ‘ABC…Z’, ‘abc….z’), translate(’yellow’, ‘ABC…Z’, ‘abc….z’))

I think XML is a very simple storage medium that you can save and query in it. But all data is storage as a tree node in the XML. In this case, it can very simple to save hierarchy data structure. But how to handle it you have reference item?

Just use key in your XML code. For more detail please refer the sample as follow:

t1.xslt

<?xml version="1.0" encoding="UTF-8"?><br /> <xsl:stylesheet version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform"><br /> <xsl:key name="ownerById" match="item" use="@ID"/><br /> <xsl:output indent="yes"/><br /> <xsl:template match="RefItem"><br /> <xsl:text><br /> ———————————————————————————<br /> Result<br /> ———————————————————————————<br /> </xsl:text><br /> <xsl:for-each select="item"><br /> <xsl:if test="key(’ownerById’, @refID)//name"><br /> <xsl:text disable-output-escaping="yes"><br /> &lt;item ID="</xsl:text></p> <p><xsl:value-of select="@ID"/></p> <p><xsl:text disable-output-escaping="yes">" refID="</xsl:text></p> <p><xsl:value-of select="@refID"/></p> <p><xsl:text disable-output-escaping="yes">"><br /> &lt;name></xsl:text></p> <p><xsl:value-of select="key(’ownerById’, @refID)//name"/></p> <p><xsl:text disable-output-escaping="yes">&lt;/name><br /> &lt;adress></xsl:text><br /> <xsl:value-of select="key(’ownerById’, @refID)//adress"/></p> <p><xsl:text disable-output-escaping="yes">&lt;/adress><br /> &lt;/item><br /> </xsl:text><br /> </xsl:if></p> <p> </xsl:for-each><br /> </xsl:template><br /> <xsl:template match="@* | node()"><br /> <xsl:copy><br /> <xsl:apply-templates select="@* | node()"/><br /> </xsl:copy><br /> </xsl:template><br /> </xsl:stylesheet>

x1.xml

<test><br /> <item ID ="100"><br /> <name>J. Smith</name><br /> <adress>Taipei, Taiwan</adress><br /> </item><br /> <!–<br /> <item ID ="110"><br /> <name>E. Rock</name><br /> <adress>CA, US</adress><br /> </item><br /> –><br /> <item ID ="120"><br /> <name>R. Paul</name><br /> <adress>TAIWAN, SA</adress><br /> </item><br /> <item ID ="130"><br /> <name>E. Rock</name><br /> <adress>CA, US</adress><br /> </item><br /> <RefItem><br /> <item ID ="151" refID="130"/><br /> <item ID ="152" refID="120"/><br /> <item ID ="153" refID="130"/><br /> <item ID ="154" refID="110"/><br /> <item ID ="155" refID="100"/><br /> </RefItem><br /> </test>

Result

<?xml version="1.0" encoding="utf-8"?><br /> <test><br /> <item ID="100"><br /> <name>J. Smith</name><br /> <adress>Taipei, Taiwan</adress><br /> </item><br /> <!–<br /> <item ID ="110"><br /> <name>E. Rock</name><br /> <adress>CA, US</adress><br /> </item><br /> –><br /> <item ID="120"><br /> <name>R. Paul</name><br /> <adress>TAIWAN, SA</adress><br /> </item><br /> <item ID="130"><br /> <name>E. Rock</name><br /> <adress>CA, US</adress><br /> </item></p> <p>———————————————————————————<br /> Result<br /> ———————————————————————————</p> <p> <item ID="151" refID="130"><br /> <name>E. Rock</name><br /> <adress>CA, US</adress><br /> </item></p> <p> <item ID="152" refID="120"><br /> <name>R. Paul</name><br /> <adress>TAIWAN, SA</adress><br /> </item></p> <p> <item ID="153" refID="130"><br /> <name>E. Rock</name><br /> <adress>CA, US</adress><br /> </item></p> <p> <item ID="155" refID="100"><br /> <name>J. Smith</name><br /> <adress>Taipei, Taiwan</adress><br /> </item></p> <p></test>

I have summerized some note about the string comparison via XSLT and XPATH.

1. Find specific string with "=":
   Find specific Item with text "testITEM".
   
   <xsl:apply-templates select="//*[Item[text() = ‘testITEM’]]">
   </xsl:apply-templates>
2. Find specific string with "contains":
   Find specific Item which contain "testITEM".

   <xsl:apply-templates select="//*[contains(Item,’testITEM’]">
   </xsl:apply-templates>

3. Find specific string  case-insensitivity "=":
   Find specific Item with text "testITEM" or "TESTITEM" or "TestItem" … ETC.

   There is no way to compare it without transform, you need transform it to upper case(or small case) first.

   <xsl:variable name="UperCase">ABCDEFGHIJKLMNOPQRSTUVWXYZ</xsl:variable>
   <xsl:variable name="LowerCase">abcdefghijklmnopqrstuvwxyz</xsl:variable>

   <xsl:apply-templates select="//*[Item[translate(text(), $UperCase, $LowerCase) = translate(’testITEM’, $UperCase, $LowerCase)]]">
   </xsl:apply-templates>

4. Compare orderings with great-than:
   Find specific date which great than "20060419":
   
   If the date is ISO format (YYYY-MM-DD) it is easy to compare with follow code. ( >= is the same case.)

   <xsl:apply-templates select="//*[date[translate(text(), ‘-’, ”) > translate(’2006-04-19′, ‘-’, ”)]]">
   </xsl:apply-templates>

5. Compare orderings with less-than:
   Find specific date which less than "20060419":

   It should be note, "<" can not in XPATH. Please use "&lt;" to replace it. "<=" is the same code.

   <xsl:apply-templates select="//*[date[translate(text(), ‘-’, ”) < translate(’2006-04-19′, ‘-’, ”)]]">
   </xsl:apply-templates>

That is all, for more detail you can find some useful feedback in XSLT Questions and Answers.