sort on date field with fallback to updatedate

Press Ctrl / CMD + C to copy this to your clipboard.

Copied to clipboard

Flag this post as spam?

This post will be reported to the moderators as potential spam to be looked at

Bo Damgaard Mortensen 712 posts 1189 karma points

Mar 07, 2013 @ 14:55
0

Sort on date field with fallback to updateDate
Hi all,

Is it possible in XSLT to sort on a date field (a regular Date Picker datatype) and if it's not set on the current node, then sort on the updateDate instead?

Something along the lines of this:
```
<xsl:sort select="myDate | @updateDate" order="descending" />
```
Is this possible? :-)
Copy Link

Fuji Kusaka 2203 posts 4220 karma points

Mar 07, 2013 @ 15:15

In Xslt not sure if this will work

<xsl:sortselect="myDate | @updateDate"order="descending"/>

this might though

<xsl:choose>
  <xsl:when test="string('datePicker') = ' '">
 <xsl:sortselect="datePicker"order="descending"/>
  </xsl:when>
<xsl:otherwise>
 <xsl:sortselect="@createDate"order="descending"/>
</xsl:otherwise>
</xsl:choose>

Not sure though

Copy Link

sami 22 posts 104 karma points

Mar 07, 2013 @ 15:16

Hi,

I think it's possible:

<xsl:for-each select="page">
    <xsl:sort select="myDate" order="descending"/>
    <xsl:sort select="@updateDate" order="descending"/>
</xsl:for-each>

Copy Link

Dennis Aaen 4457 posts 17970 karma points admin hq c-trib

Mar 07, 2013 @ 15:24
0
Hi,

I think it´s possible.
```
<xsl:sort select="(./myDate[normalize-space() != '']|@updateDate)"order="descending"/>
```
Copy Link
Bo Damgaard Mortensen 712 posts 1189 karma points

Mar 07, 2013 @ 15:33
2
Hi all,

Thanks a lot for your inputs :-) I managed to get it to work by using this:
```
<xsl:sort select="(@updateDate[not(normalize-space(../myDate))] | myDate)[1]" order="descending"/> 
```
Credit goes to Chriztian Steinmeier!
Copy Link
Fuji Kusaka 2203 posts 4220 karma points

Mar 07, 2013 @ 15:35

0

Nice one!!

Copy Link
is working on a reply...

This forum is in read-only mode while we transition to the new forum.

You can continue this topic on the new forum by tapping the "Continue discussion" link below.

Please Sign in or register to post replies

Flag this post as spam?

Sort on date field with fallback to updateDate