[XSL-LIST Mailing List Archive Home] [By Thread] [By Date] [Recent Entries] [Reply To This Message] FW: Sort on multiple key
Ok I've managed to get my sort working. I'm trying to produce a PDF document using fop. When printing a line need to determine if the customer name is the same as the previous line. If it is I only want to print some values otherwise all values. However I cant get the test for the previous value of the customerName to work. Any assistance would be helpful. Regards Jan <xsl:for-each select="REPORT/Rollover/RolloverForecast/summaryAccount/element/rollover Date"> <xsl:sort select="." order="ascending" data-type="text"/> <xsl:sort select="concat(substring(translate(ancestor::summaryAccount/mfAccountNo, '	',''),1,5),substring(translate(ancestor::summaryAccount/mfAccountN o,'	',''),8,5),substring(translate(ancestor::summaryAccount/mfAccoun tNo,'	',''),6,2))" order="ascending" data-type="text"/> <xsl:for-each select="ancestor::element"> <fo:table-row keep-with-previous="keep"> <xsl:choose> <xsl:when test="preceding::rolloverDate/ancestor::summaryAccount/customerName = ancestor::customerName"> <fo:table-cell keep-with-previous="keep"> <fo:block space-before.optimum="5pt" space-after.optimum="5pt" font-size="10pt" text-align="left"> </fo:block> </fo:table-cell> <fo:table-cell> <fo:block space-before.optimum="5pt" space-after.optimum="5pt" font-size="10pt" text-align="end"> </fo:block> </fo:table-cell> <fo:table-cell> <fo:block space-before.optimum="5pt" space-after.optimum="5pt" font-size="10pt" text-align="end"> </fo:block> </fo:table-cell> </xsl:when> <xsl:otherwise> <fo:table-cell keep-with-previous="keep"> <fo:block space-before.optimum="5pt" space-after.optimum="5pt" font-size="10pt" text-align="left"> <xsl:value-of select="preceding-sibling::customerName"/> </fo:block> </fo:table-cell> <fo:table-cell> <fo:block space-before.optimum="5pt" space-after.optimum="5pt" font-size="10pt" text-align="end"> <xsl:value-of select="preceding-sibling::mfAccountNo"/> </fo:block> </fo:table-cell> <fo:table-cell> <fo:block space-before.optimum="5pt" space-after.optimum="5pt" font-size="10pt" text-align="end"> <xsl:value-of select="parent::summaryAccount/@id"/> </fo:block> </fo:table-cell> </xsl:otherwise> </xsl:choose> -----Original Message----- From: Hesselberth, Jan Sent: 20 May 2008 11:15 To: xsl-list@xxxxxxxxxxxxxxxxxxxxxx Subject: Sort on multiple key I have the xml below which needs to be sorted into key1 key2 order. I can sort it in key1 order ok but can't get the key2 order. I tried this but it doesn't work. I then need to be able to process the sorted xml by element. Can you tell me where I'm going wrong please. Regards Jan Hesselberth <xsl:for-each select="SummaryNo/element/key1"> <xsl:sort select="." order="ascending" data-type="text"/> <xsl:for-each select="ancestor::SummaryNo/key2"> <xsl:sort select="." order="ascending" data-type="text"/> <xsl:for-each select="preceding::element"> <SummaryNo id="123456789"> <key2>12345K00348</key2> <customerName>Investments Limited</customerName> <element id="4"> <key1>2008-04-16</key1> <rolloverResult> <errorDescription>calculateInterestCharge failed</errorDescription> </rolloverResult> </element> <element id="5"> <key1>2008-04-16</key1> <rolloverResult> <errorDescription>calculateInterestCharge failed</errorDescription> </rolloverResult> </element> <element id="6"> <key1>2008-04-18</key1> <rolloverResult> <errorDescription>calculateInterestCharge failed</errorDescription> </rolloverResult> </element> </SummaryNo> <SummaryNo id="234567890"> <key2>56789D00172</key2> <customerName>Freds Developments Limited</customerName> <element id="4"> <key1>2008-04-17</key1> <rolloverResult> <errorDescription>calculateInterestCharge failed</errorDescription> </rolloverResult> </element> <element id="5"> <key1>2008-04-16</key1> <rolloverResult> <errorDescription>calculateInterestCharge failed</errorDescription> </rolloverResult> </element> </SummaryNo> <SummaryNo id="145678999"> <key2>44551J00106</key2> <customerName>Housing Trust Limited</customerName> <element id="1"> <key1>2008-04-16</key1> <rolloverResult> <errorDescription>calculateInterestCharge failed</errorDescription> </rolloverResult> </element> <element id="2"> <key1>2008-04-15</key1> <rolloverResult> <errorDescription>calculateInterestCharge failed</errorDescription> </rolloverResult> </element> <element id="3"> <key1>2008-04-17</key1> <rolloverResult> <errorDescription>calculateInterestCharge failed</errorDescription> </rolloverResult> </element> </SummaryNo> LEGAL NOTICE The information contained in this e-mail and any attachments are private and confidential. This message is solely intended for a particular recipient, if you are not the intended recipient you are prohibited from storing, copying, disseminating or using the information in any way. If you received this e-mail in error please notify the sender immediately. E-mail transmission cannot be guaranteed to be secure or error-free as information could be intercepted, corrupted, lost, destroyed, arrive late or incomplete, or contain viruses. The sender therefore does not accept liability for any errors, viruses or omissions in the contents of this message, which arise as a result of transmission. This e-mail is not intended to create legally binding commitments on behalf of Northern Rock plc, nor do its contents reflect the corporate views or policies of Northern Rock plc. Northern Rock plc, Registered Office Northern Rock House Gosforth Newcastle upon Tyne NE3 4PL. Registered in England, number 3273685. Telephone No: 0191 2857191 Northern Rock plc is authorised and regulated by the Financial Services Authority for deposit-taking; advising on and arranging mortgages and general insurance; and for introducing life assurance and investments. ______________________________________________________________________ This email has been scanned by the MessageLabs Email Security System. For more information please visit http://www.messagelabs.com/email ______________________________________________________________________
|
PURCHASE STYLUS STUDIO ONLINE TODAY!Purchasing Stylus Studio from our online shop is Easy, Secure and Value Priced! Download The World's Best XML IDE!Accelerate XML development with our award-winning XML IDE - Download a free trial today! Subscribe in XML format
|