Grouping Across Multiple Documents
Our final task will be to group our collection of purchase orders. We’ll create a new listing that groups all the purchase orders by the state to which they were shipped. We’ll use the grouping technique we used earlier in Chapter 7.
We’ll define an XSLT key() for all of the <state> values in our set of purchase
orders. We’ll also create a variable that stores all of these orders. By
reading all of the purchase orders into a variable, we won’t have to
call the document() function
every time we need to access a particular purchase order. With those two
structures in place, we’ll be ready to do grouping just as we did in the
last chapter.
To get things started, here’s how we define the key():
<xsl:key name="po-key" match="purchase-order" use="customer/address/state"/>
And here’s how we load all of the purchase order documents into a variable:
<xsl:variable name="purchase-orders" select="document(/report/po/@filename)/purchase-order"/>
Now that we have a variable that contains all of the nodes from all of the purchase orders, we’re ready to process them. We’ll go through these steps:
Start an
<xsl:for-each>element to process all of the nodes in the variable$purchase-orders.Sort the purchase orders by state name. As with our previous stylesheet, this means using the
document('')function to retrieve the state name that matches the abbreviation in the purchase order.Save the value of the current
<state>in a variable.Use the
key()function to save into a ...
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Read now
Unlock full access