StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

PO
primarykey
Id
20224530
data
AcceptedAnswerId
0
AnswerCount
0
ClosedDate
CommentCount
1
CommunityOwnedDate
CreationDate
2013-11-26T17:58:12.243
FavoriteCount
0
LastActivityDate
2013-11-26T17:58:12.243
LastEditDate
LastEditorUserId
0
OwnerUserId
7585
ParentId
20220251
PostTypeId
2
Score
1
ViewCount
0
LastEditorDisplayName
text
Body
You don't need to use an inner xsl:for-each loop here to look up the company name. You could just use an xsl:variable here with a select parameter where you can put your 'contains' expressions <pre><code><xsl:for-each select="Report_Data/Report_Entry"> <xsl:variable name="company_name" select="/Report_Data/Company_Data/Report_Entry[contains(current()/company_id, code)]/name" /> </code></pre> Note the use of current() here, which is to ensure the expression uses the company_id of the current Report_Data/Report_Entry element you are on, as opposed to the Company_Data/Report_Entry you are searching in the expression. If you were to do what you were currently doing, namely <code>/Report_Data/Report_Entry/company_id</code>, then this is an 'absolute' expression which starts from the top-level document node and will always return the first company_id in the XML. But in anycase, you could then simply output this variable, or use an xsl:choose to output 'NA' instead should the variable be empty (i.e No company name was found). Were it not for the fact the ids do not match up, such looking up of values are usually better handled with a key. To look up an Report_Entry by its code you would define a key like so <pre><code><xsl:key name="company" match="Company_Data/Report_Entry" use="code" /> </code></pre> Then to look it up you could do something like this... <pre><code><xsl:for-each select="Report_Data/Report_Entry"> <xsl:variable name="company_name" select="key('company', company_id)" /> </code></pre> Of course, this would fail in your case because the ids are not exactly the same, but perhaps you can just remove leading zeroes. Try this, perhaps. <pre><code><xsl:for-each select="Report_Data/Report_Entry"> <xsl:variable name="company_name" select="key('company', number(company_id))" /> </code></pre>
Tags
Title
singulars
PostAcceptedAnswerId
1. This table or related slice is empty.
PostParentId
1. POCall Template with Parameter and Output Value - XSLT
 singulars
 PostTypePostTypeId
 PTQuestion
PostTypePostTypeId
1. PTAnswer
UserLastEditorUserId
1. This table or related slice is empty.
UserOwnerUserId
1. USTim C
plurals
PostLinksPostIdRelatedPostId
1. This table or related slice is empty.
PostLinksRelatedPostIdPostId
1. This table or related slice is empty.
PostsAcceptedAnswerId
1. POCall Template with Parameter and Output Value - XSLT
 singulars
 PostTypePostTypeId
 PTQuestion
PostsParentIdCreationDate
1. This table or related slice is empty.
VotesPostIdCreationDate
1. VO
 singulars
 PostPostId
 PO
 UserUserId
 This table or related slice is empty.
 VoteTypeVoteTypeId
 VTUpMod
2. VO
 singulars
 PostPostId
 PO
 UserUserId
 This table or related slice is empty.
 VoteTypeVoteTypeId
 VTAcceptedByOriginator
CommentsPostId
1. COThank you. Your first method using the variable worked.
 singulars
 PostPostId
 PO
 UserUserId
 USRXC

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.