xsl:sort - InfoPath Dev
in

InfoPath Dev

xsl:sort

Last post 01-23-2007 09:37 AM by Greg Collins. 1 replies.
Page 1 of 1 (2 items)
Sort Posts: Previous Next
  • 01-20-2007 05:28 PM

    • colabi
    • Not Ranked
    • Joined on 01-21-2007
    • Posts 1

    xsl:sort

    hi, please help

    i have a repeating section with a date field. i want to sort this
    dates descending, when i open the form, using xsl:sort; but i dont know where
    to put "xsl:sort" it in view1.xsl.

    thanks

    this is my xsl:


    <?xml version="1.0" encoding="UTF-8"?>
    <xsl:stylesheet version="1.0" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xhtml="http://www.w3.org/1999/xhtml" xmlns:ns1="http://schemas.microsoft.com/office/infopath/2003/myXSD/2007-01-10T21:06:29" xmlns:svc="http://schemas.microsoft.com/office/infopath/2003/sample/ServiceRequest" xmlns:my="http://schemas.microsoft.com/office/infopath/2003/myXSD/2007-01-08T20:18:15" xmlns:xd="http://schemas.microsoft.com/office/infopath/2003" xmlns:xsl="http://www.w3.org/1999/XSL/Transform" xmlns:msxsl="urn:schemas-microsoft-com:xslt" xmlns:x="urn:schemas-microsoft-com:office:excel" xmlns:xdExtension="http://schemas.microsoft.com/office/infopath/2003/xslt/extension" xmlns:xdXDocument="http://schemas.microsoft.com/office/infopath/2003/xslt/xDocument" xmlns:xdSolution="http://schemas.microsoft.com/office/infopath/2003/xslt/solution" xmlns:xdFormatting="http://schemas.microsoft.com/office/infopath/2003/xslt/formatting" xmlns:xdImage="http://schemas.microsoft.com/office/infopath/2003/xslt/xImage" xmlns:xdUtil="http://schemas.microsoft.com/office/infopath/2003/xslt/Util" xmlns:xdMath="http://schemas.microsoft.com/office/infopath/2003/xslt/Math" xmlns:xdDate="http://schemas.microsoft.com/office/infopath/2003/xslt/Date" xmlns:sig="http://www.w3.org/2000/09/xmldsig#" xmlns:xdSignatureProperties="http://schemas.microsoft.com/office/infopath/2003/SignatureProperties">
    <xsl:output method="html" indent="no"/>
    <xsl:template match="my:myFields">
    <html>
    <head>
    <meta http-equiv="Content-Type" content="text/html"></meta>
    <style controlStyle="controlStyle">@media screen { BODY{margin-left:21px;background-position:21px 0px;} } BODY{color:windowtext;background-color:window;layout-grid:none;} .xdListItem {display:inline-block;width:100%;vertical-align:text-top;} .xdListBox,.xdComboBox{margin:1px;} .xdInlinePicture{margin:1px; BEHAVIOR: url(#default#urn::xdPicture) } .xdLinkedPicture{margin:1px; BEHAVIOR: url(#default#urn::xdPicture) url(#default#urn::controls/Binder) } .xdSection{border:1pt solid #FFFFFF;margin:6px 0px 6px 0px;padding:1px 1px 1px 5px;} .xdRepeatingSection{border:1pt solid #FFFFFF;margin:6px 0px 6px 0px;padding:1px 1px 1px 5px;} .xdBehavior_Formatting {BEHAVIOR: url(#default#urn::controls/Binder) url(#default#Formatting);} .xdBehavior_FormattingNoBUI{BEHAVIOR: url(#default#CalPopup) url(#default#urn::controls/Binder) url(#default#Formatting);} .xdExpressionBox{margin: 1px;padding:1px;word-wrap: break-word;text-overflow: ellipsis;overflow-x:hidden;}.xdBehavior_GhostedText,.xdBehavior_GhostedTextNoBUI{BEHAVIOR: url(#default#urn::controls/Binder) url(#default#TextField) url(#default#GhostedText);} .xdBehavior_GTFormatting{BEHAVIOR: url(#default#urn::controls/Binder) url(#default#Formatting) url(#default#GhostedText);} .xdBehavior_GTFormattingNoBUI{BEHAVIOR: url(#default#CalPopup) url(#default#urn::controls/Binder) url(#default#Formatting) url(#default#GhostedText);} .xdBehavior_Boolean{BEHAVIOR: url(#default#urn::controls/Binder) url(#default#BooleanHelper);} .xdBehavior_Select{BEHAVIOR: url(#default#urn::controls/Binder) url(#default#SelectHelper);} .xdRepeatingTable{BORDER-TOP-STYLE: none; BORDER-RIGHT-STYLE: none; BORDER-LEFT-STYLE: none; BORDER-BOTTOM-STYLE: none; BORDER-COLLAPSE: collapse; WORD-WRAP: break-word;}.xdScrollableRegion{BEHAVIOR: url(#default#ScrollableRegion);} .xdMaster{BEHAVIOR: url(#default#MasterHelper);} .xdActiveX{margin:1px; BEHAVIOR: url(#default#ActiveX);} .xdFileAttachment{display:inline-block;margin:1px;BEHAVIOR:url(#default#urn::xdFileAttachment);} .xdPageBreak{display: none;}BODY{margin-right:21px;} .xdTextBoxRTL{display:inline-block;white-space:nowrap;text-overflow:ellipsis;;padding:1px;margin:1px;border: 1pt solid #dcdcdc;color:windowtext;background-color:window;overflow:hidden;text-align:right;} .xdRichTextBoxRTL{display:inline-block;;padding:1px;margin:1px;border: 1pt solid #dcdcdc;color:windowtext;background-color:window;overflow-x:hidden;word-wrap:break-word;text-overflow:ellipsis;text-align:right;font-weight:normal;font-style:normal;text-decoration:none;vertical-align:baseline;} .xdDTTextRTL{height:100%;width:100%;margin-left:22px;overflow:hidden;padding:0px;white-space:nowrap;} .xdDTButtonRTL{margin-right:-21px;height:18px;width:20px;behavior: url(#default#DTPicker);}.xdTextBox{display:inline-block;white-space:nowrap;text-overflow:ellipsis;;padding:1px;margin:1px;border: 1pt solid #dcdcdc;color:windowtext;background-color:window;overflow:hidden;text-align:left;} .xdRichTextBox{display:inline-block;;padding:1px;margin:1px;border: 1pt solid #dcdcdc;color:windowtext;background-color:window;overflow-x:hidden;word-wrap:break-word;text-overflow:ellipsis;text-align:left;font-weight:normal;font-style:normal;text-decoration:none;vertical-align:baseline;} .xdDTPicker{;display:inline;margin:1px;margin-bottom: 2px;border: 1pt solid #dcdcdc;color:windowtext;background-color:window;overflow:hidden;} .xdDTText{height:100%;width:100%;margin-right:22px;overflow:hidden;padding:0px;white-space:nowrap;} .xdDTButton{margin-left:-21px;height:18px;width:20px;behavior: url(#default#DTPicker);} .xdRepeatingTable TD {VERTICAL-ALIGN: top;}</style>
    <style tableEditor="TableStyleRulesID">TABLE.xdLayout TD {
    BORDER-RIGHT: medium none; BORDER-TOP: medium none; BORDER-LEFT: medium none; BORDER-BOTTOM: medium none
    }
    TABLE.msoUcTable TD {
    BORDER-RIGHT: 1pt solid; BORDER-TOP: 1pt solid; BORDER-LEFT: 1pt solid; BORDER-BOTTOM: 1pt solid
    }
    TABLE {
    BEHAVIOR: url (#default#urn::tables/NDTable)
    }
    </style>
    <style languageStyle="languageStyle">BODY {
    FONT-SIZE: 10pt; FONT-FAMILY: Verdana
    }
    TABLE {
    FONT-SIZE: 10pt; FONT-FAMILY: Verdana
    }
    SELECT {
    FONT-SIZE: 10pt; FONT-FAMILY: Verdana
    }
    .optionalPlaceholder {
    PADDING-LEFT: 20px; FONT-WEIGHT: normal; FONT-SIZE: xx-small; BEHAVIOR: url(#default#xOptional); COLOR: #333333; FONT-STYLE: normal; FONT-FAMILY: Verdana; TEXT-DECORATION: none
    }
    .langFont {
    FONT-FAMILY: Verdana
    }
    .defaultInDocUI {
    FONT-SIZE: xx-small; FONT-FAMILY: Verdana
    }
    .optionalPlaceholder {
    PADDING-RIGHT: 20px
    }
    </style>
    <style themeStyle="urn:office.microsoft.com:themeBlue">BODY {
    COLOR: black; BACKGROUND-COLOR: white
    }
    TABLE {
    BORDER-RIGHT: medium none; BORDER-TOP: medium none; BORDER-LEFT: medium none; BORDER-BOTTOM: medium none; BORDER-COLLAPSE: collapse
    }
    TD {
    BORDER-LEFT-COLOR: #517dbf; BORDER-BOTTOM-COLOR: #517dbf; BORDER-TOP-COLOR: #517dbf; BORDER-RIGHT-COLOR: #517dbf
    }
    TH {
    BORDER-LEFT-COLOR: #517dbf; BORDER-BOTTOM-COLOR: #517dbf; COLOR: black; BORDER-TOP-COLOR: #517dbf; BACKGROUND-COLOR: #cbd8eb; BORDER-RIGHT-COLOR: #517dbf
    }
    .xdTableHeader {
    COLOR: black; BACKGROUND-COLOR: #ebf0f9
    }
    P {
    MARGIN-TOP: 0px
    }
    H1 {
    MARGIN-TOP: 0px; MARGIN-BOTTOM: 0px; COLOR: #1e3c7b
    }
    H2 {
    MARGIN-TOP: 0px; MARGIN-BOTTOM: 0px; COLOR: #1e3c7b
    }
    H3 {
    MARGIN-TOP: 0px; MARGIN-BOTTOM: 0px; COLOR: #1e3c7b
    }
    H4 {
    MARGIN-TOP: 0px; MARGIN-BOTTOM: 0px; COLOR: #1e3c7b
    }
    H5 {
    MARGIN-TOP: 0px; MARGIN-BOTTOM: 0px; COLOR: #517dbf
    }
    H6 {
    MARGIN-TOP: 0px; MARGIN-BOTTOM: 0px; COLOR: #ebf0f9
    }
    .primaryVeryDark {
    COLOR: #ebf0f9; BACKGROUND-COLOR: #1e3c7b
    }
    .primaryDark {
    COLOR: white; BACKGROUND-COLOR: #517dbf
    }
    .primaryMedium {
    COLOR: black; BACKGROUND-COLOR: #cbd8eb
    }
    .primaryLight {
    COLOR: black; BACKGROUND-COLOR: #ebf0f9
    }
    .accentDark {
    COLOR: white; BACKGROUND-COLOR: #517dbf
    }
    .accentLight {
    COLOR: black; BACKGROUND-COLOR: #ebf0f9
    }
    </style>
    </head>
    <body>
    <div/>
    <div/>
    <div><xsl:apply-templates select="my:group1/my:appointment" mode="_1"/>
    </div>
    </body>
    </html>
    </xsl:template>
    <xsl:template match="my:appointment" mode="_1">
    <div class="xdRepeatingSection xdRepeating" title="" style="BORDER-RIGHT: #000000 1pt; PADDING-RIGHT: 0px; BORDER-TOP: #000000 1pt; PADDING-LEFT: 0px; PADDING-BOTTOM: 0px; MARGIN: 0px; BORDER-LEFT: #000000 1pt; WIDTH: 569px; PADDING-TOP: 0px; BORDER-BOTTOM: #000000 1pt; BACKGROUND-COLOR: transparent" align="left" xd:CtrlId="CTRL1" xd:xctname="RepeatingSection" tabIndex="-1">
    <div>
    <div class="xdDTPicker" title="" style="BORDER-RIGHT: #000000 1pt; BORDER-TOP: #000000 1pt; FONT-SIZE: 9pt; BORDER-LEFT: #000000 1pt; WIDTH: 130px; BORDER-BOTTOM: #000000 1pt; BACKGROUND-COLOR: transparent" noWrap="1" xd:CtrlId="CTRL78" xd:xctname="DTPicker"><span class="xdDTText xdBehavior_FormattingNoBUI" hideFocus="1" contentEditable="true" tabIndex="0" xd:xctname="DTPicker_DTText" xd:innerCtrl="_DTText" xd:datafmt=""date","dateFormat:Short Date;"" xd:boundProp="xd:num" xd:binding="my:group8/my:field1">
    <xsl:attribute name="xd:num">
    <xsl:value-of select="my:group8/my:field1"/>
    </xsl:attribute>
    <xsl:choose>
    <xsl:when test="function-available('xdFormatting:formatString')">
    <xsl:value-of select="xdFormatting:formatString(my:group8/my:field1,"date","dateFormat:Short Date;")"/>
    </xsl:when>
    <xsl:otherwise>
    <xsl:value-of select="my:group8/my:field1"/>
    </xsl:otherwise>
    </xsl:choose>
    </span>
    <button class="xdDTButton" xd:xctname="DTPicker_DTButton" xd:innerCtrl="_DTButton" tabIndex="-1">
    <img src="res://infopath.exe/calendar.gif" Linked="true"/>
    </button>
    </div>
    </div>
    </div>
    </xsl:template>
    </xsl:stylesheet>
  • 01-23-2007 09:37 AM In reply to

    You would add it as a child of apply-templates.

    However, xsl:sort does not "round trip" in the InfoPath designer... meaning that InfoPath will either strip it out completely, or it will mess it up in some other way. The only way around this is to use it inside of a preserve code block (xd:preserve). You should be able to find information on this topic in these forums.
Page 1 of 1 (2 items)
Copyright © 2003-2019 Qdabra Software. All rights reserved.
View our Terms of Use.