SSDN - sort date but some dates may be blank

XML Editor

Sign Up

Search

Options

Chat

Help

News

Log in

Not Logged in

Topic

Topic Page 1 2 3 4 5 6 7 8 9

J M

Subject: sort date but some dates may be blank
Author: J M
Date: 16 Feb 2010 11:18 PM

Hi,
Need some help. I have a source structure simplified as:

<Material> (1..n)
<Parameters> (1..n)
<Text>
<Name>Test</Name>
</Text>
<ValidTo>2009-06-29</ValidTo>
</Parameters>
<Parameters>
<Text>
<Name>Test</Name>
</Text>
<ValidTo/>
</Parameters>
</Material>

Target structure is very similar however I need to output the parameters sorted by Name and by ValidTo ascending. As shown in the above example, ValidTo is sometimes blank which signifies it is valid indefinitely therefore should be last in the sorted list. If I sort the source ascending, the blanks appear first. How can I sort by name and validto with these blanks appearing in the correct place OR alternatively, how I can modify the source validTo to put in a dummy date e.g 9999-12-31 before the sort (consequently the sort will work as expected)?

Thanks in advance!

Topic Page 1 2 3 4 5 6 7 8 9

Powered by Stylus Studio, the world's leading XML IDE for XML, XSLT, XQuery, XML Schema, DTD, XPath, WSDL, XHTML, SQL/XML, and XML Mapping!

Go to Conference:

Log In Options Username: Password:

Site Map | Privacy Policy | Terms of Use | Trademarks

Stylus Studio® and DataDirect XQuery ™are from DataDirect Technologies, is a registered trademark of Progress Software Corporation, in the U.S. and other countries. © 2004-2016 All Rights Reserved.