StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

POXSL associative sorting using a field substring
primarykey
Id
4451576
data
AcceptedAnswerId
4451860
AnswerCount
2
ClosedDate
CommentCount
2
CommunityOwnedDate
CreationDate
2010-12-15T15:24:12.323
FavoriteCount
0
LastActivityDate
2010-12-15T16:46:32.050
LastEditDate
2010-12-15T15:51:11.650
LastEditorUserId
198011
OwnerUserId
198011
ParentId
0
PostTypeId
1
Score
1
ViewCount
438
LastEditorDisplayName
text
Body
The transformation I am writing must compose a comma separated string value from a given node set. The resulting string must be sorted according to a random (non-alphabetic) mapping for the first character in the input values. I came up with this: <pre><code><?xml version="1.0" encoding="utf-8"?> <xsl:stylesheet version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform" xmlns:tmp="http://tempuri.org" exclude-result-prefixes="tmp" > <xsl:output method="xml" indent="yes"/> <tmp:sorting-criterion> <code value="A">5</code> <code value="B">1</code> <code value="C">3</code> </tmp:sorting-criterion> <xsl:template match="/InputValueParentNode"> <xsl:element name="OutputValues"> <xsl:for-each select="InputValue"> <xsl:sort select="document('')/*/tmp:sorting-criterion/code[@value=substring(.,1,1)]" data-type="number"/> <xsl:value-of select="normalize-space(.)"/> <xsl:if test="position() != last()"> <xsl:text>,</xsl:text> </xsl:if> </xsl:for-each> </xsl:element> </xsl:template> </xsl:stylesheet> </code></pre> It doesn't work and looks like the XPath <code>document('')/*/tmp:sorting-criterion/code[@value=substring(.,1,1)]</code> does not evaluate as I expect. I've checked to substitute the <code>substring(.,1,1)</code> for a literal and it evaluates to the proper value. So, am I missing something that makes the sorting XPath expression not to evaluate as I expect or is it simply impossile to do it this way? If not possible to create a XPath expression that works, is there a work around to achieve my purpose? Note: I'm constrained to XSLT-1.0 Sample Input: <pre><code><?xml version="1.0" encoding="utf-8"?> <InputValueParentNode> <InputValue>A input value</InputValue> <InputValue>B input value</InputValue> <InputValue>C input value</InputValue> </InputValueParentNode> </code></pre> Expected ouput: <pre><code><?xml version="1.0" encoding="utf-8"?> <OutputValues>B input value,C input value,A input value</OutputValues> </code></pre>
Tags
<xslt>
Title
XSL associative sorting using a field substring
singulars
PostAcceptedAnswerId
1. PO
 singulars
 PostTypePostTypeId
 PTAnswer
PostParentId
1. This table or related slice is empty.
PostTypePostTypeId
1. PTQuestion
UserLastEditorUserId
1. USAntonio Pérez
UserOwnerUserId
1. USAntonio Pérez
plurals
PostLinksPostIdRelatedPostId
1. PL
 singulars
 LinkTypeLinkTypeId
 LTLinked
PostLinksRelatedPostIdPostId
1. This table or related slice is empty.
PostsAcceptedAnswerId
1. This table or related slice is empty.
PostsParentIdCreationDate
1. PO
 singulars
 PostTypePostTypeId
 PTAnswer
2. PO
 singulars
 PostTypePostTypeId
 PTAnswer
VotesPostIdCreationDate
1. VO
 singulars
 PostPostId
 POXSL associative sorting using a field substring
 UserUserId
 This table or related slice is empty.
 VoteTypeVoteTypeId
 VTUpMod
CommentsPostId
1. COCould you provide example input and expected output?
 singulars
 PostPostId
 POXSL associative sorting using a field substring
 UserUserId
 USwdebeaum
2. CO@wdebeaum: question edited to include both. Cheers.
 singulars
 PostPostId
 POXSL associative sorting using a field substring
 UserUserId
 USAntonio Pérez

Querying!

Guidance

A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.