help with nested xslt sort by

Go to solution

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

Paul Griffiths 370 posts 1021 karma points

Apr 16, 2014 @ 15:44
0

Help with nested xslt sort by

XSLT
Hi all

I am trying to use a nested xslt sort by 2 parameters.

I am looking to sort by venueName and also I have 5 premium venues that need to be displayed at the top also by venueName

I have a property 'isPremiumVenue' and this is a true/false data type.

So, in summary: sort by venueName and then sort where isPremiumVenue = 1 (so they display at the top of the results, all other non-premium venues to show underneath in venueName order)

here is my code
```
<xsl:variable name="premiumVenue" select="$sectionNode/isPremiumVenue = '1'" />

            <xsl:sort select="venueName" order="ascending"/>
<xsl:sort select="$premiumVenue" order="ascending"/>        
```
Could you help please?

Thanks

Paul
Copy Link
Chriztian Steinmeier 2798 posts 8788 karma points MVP 7x admin c-trib

Apr 16, 2014 @ 17:03
100
Hi Paul,

Use data-type="number" on the sort element and convert the boolean to a number to catch the off chance elements that don't have that property - so something like this:
```
<xsl:sort select="venueName" order="ascending"/>
<xsl:sort select="number(boolean(isPremiumVenue = 1))" data-type="number" order="descending"/>
```
/Chriztian
Copy Link
Paul Griffiths 370 posts 1021 karma points

Apr 17, 2014 @ 10:28
0
Hello Chriztian,

Sorry for taking a while to respond, i have been away from the computer. However, Once again mate you code seemed to do the trick! :)

For some reason it wouldn't work this way
```
<xsl:sort select="venueName" order="ascending"/>
<xsl:sort select="number(boolean(isPremiumVenue = 1))" data-type="number" order="descending"/>
```
but this way works
```
<xsl:sort select="number(boolean(isPremiumVenue = 1))" data-type="number" order="descending"/>
<xsl:sort select="venueName" order="ascending"/>
```
Either way I'm happy!!

Thanks again

Paul
Copy Link
Chriztian Steinmeier 2798 posts 8788 karma points MVP 7x admin c-trib

Apr 17, 2014 @ 10:34

0

Ah - but of course :) Silly me. The other way round would sort venues without the isPremiumVenue property (or having it set to false) to the top first...

/Chriztian

Copy Link
Paul Griffiths 370 posts 1021 karma points

Apr 17, 2014 @ 10:55

0

Chriztian,

Like always with your quick responses and great advice we managed to get there in the end, that is the main thing :).

This forum and the fellow members are always a great help when your having a dull moment(which is frequent with me) ha.

Paul

Copy Link
is working on a reply...

Please Sign in or register to post replies

Flag this post as spam?