如何根据wso2esb中的数据对xml元素进行排序

问题描述：

我正在使用 wso2esb.我希望使用 wso2esb 转换数据我已经完成的问题是在响应时我以降序方式获取数据我将如何排列为升序方式.

I am using wso2esb. I wish to transform the data using wso2esb i have done the issue is while response i am getting data in descending manner how would i arrange in to ascending way .

<response>
    <customer-details>
        <cusfirstname>Empire Burlesque</cusfirstname>
        <delarname>Bob Dylan</delarname>
        <cusno>254</cusno>
    </customer-details>
    <customer>
        <cusId>6</cusId>
        <customername>Bonnie Tyler</customername>
        <country>UK</country>
        <company>CBS Records</company>
        <price>9.90</price>
        <year>1988</year>
    </customer>
    <customer>
        <cusId>8</cusId>
        <customername>Dolly Parton</customername>
        <country>USA</country>
        <company>RCA</company>
        <price>9.90</price>
        <year>1982</year>
    </customer>
    <customer>
        <cusId>3</cusId>
        <customername>Gary Moore</customername>
        <country>UK</country>
        <company>Virgin records</company>
        <price>10.20</price>
        <year>1990</year>
    </customer>
    <customer>
        <cusId>5</cusId>
        <customername>Eros Ramazzotti</customername>
        <country>EU</country>
        <company>BMG</company>
        <price>9.90</price>
        <year>1997</year>
    </customer>
    <customer>
        <cusId>7</cusId>
        <customername>Bee Gees</customername>
        <country>UK</country>
        <company>Polydor</company>
        <price>10.90</price>
        <year>1998</year>
    </customer>
    <customer>
        <cusId>1</cusId>
        <customername>Dr.Hook</customername>
        <country>UK</country>
        <company>CBS</company>
        <price>8.10</price>
        <year>1973</year>
    </customer>
    <customer>
        <cusId>2</cusId>
        <customername>Rod Stewart</customername>
        <country>UK</country>
        <company>Pickwick</company>
        <price>8.50</price>
        <year>1990</year>
    </customer>
    <customer>
        <cusId>4</cusId>
        <customername>Andrea Bocelli</customername>
        <country>EU</country>
        <company>Polydor</company>
        <price>10.80</price>
        <year>1996</year>
    </customer>
    <customer>
        <cusId>12</cusId>
        <customername>Percy Sledge</customername>
        <country>USA</country>
        <company>Atlantic</company>
        <price>8.70</price>
        <year>1987</year>
    </customer>
    <customer>
        <cusId>9</cusId>
        <customername>Savage Rose</customername>
        <country>EU</country>
        <company>Mega</company>
        <price>10.90</price>
        <year>1995</year>
    </customer>
    <customer>
        <cusId>11</cusId>
        <customername>Many</customername>
        <country>USA</country>
        <company>Grammy</company>
        <price>10.20</price>
        <year>1999</year>
    </customer>
    <customer>
        <cusId>10</cusId>
        <customername>Kenny Rogers</customername>
        <country>UK</country>
        <company>Mucik Master</company>
        <price>8.70</price>
        <year>1995</year>
    </customer>
</response>

我希望根据 cusId 按升序排列 customer 标记数据，那么我将如何安排此我尝试使用 xquery 但找不到任何函数关于元素排序，cusId 应该出现在 1,2,3,...

I wish to arrange the customer tag data in ascending order based on cusId so how would i arrange this I tried with xquery but i couldn't find the any function regarding element sorting , cusId should be appear in 1,2,3,...

我将如何实现这一点，我知道 xpath 中没有此功能.

How would i achieve this i know there is no function in xpath for this.

提前致谢.

答

在 XSLT 中，当使用时，您可以使用 code> 为每个 customer.此样式表对客户进行排序:

In XSLT you can use <xsl:sort> when using <xsl:apply-templates> for each customer. This stylesheet orders the customers:

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

    <xsl:template match="@*|node()">
        <xsl:copy>
            <xsl:apply-templates select="@*|node()"/>
        </xsl:copy>
    </xsl:template>

    <xsl:template match="response">
        <xsl:copy>
            <xsl:apply-templates select="customer-details"/>
            <xsl:apply-templates select="customer">
                <xsl:sort select="cusId"/>
            </xsl:apply-templates>
        </xsl:copy>
    </xsl:template>

</xsl:stylesheet>

如何根据wso2esb中的数据对xml元素进行排序

相关推荐