I want to retrive PurchaseOrderNumber attribute

LeoMathew · September 4th, 2008, 07:19 AM

Hi,

I am using XSLT 1.0.

I want to loop through list of InvoiceLines(here there are 1 InvoiceLine each in 2 InvoicePurchaseOrder node) and for each InvoiceLine, i want to retrieve the InvoicePurchaseOrderNumber.

Code:

<InvoicePurchaseOrderSet Count="1">
      <InvoicePurchaseOrder PurchaseOrderId="173675" PurchaseOrderNumber="10074841" PurchaseOrderRevision="">
      <InvoiceLineSet Count="1">
          <InvoiceLine InvoiceLineId="85093" ItemType="LINE" LineId="0003" OrderSequence="1" Key1="173675-A-23040-M-095" ItemDescription="STANDARD" Quantity="24" QuantityUOM="PRS" UnitPrice="18.15" Amount1="435.6" Amount2="" Amount3="" FactoryId="" AdjustedSacLineAmount="" TariffCode="" Attribute1="173675" Attribute2="M" Attribute3="FLORENTINE" Attribute4="23040" Attribute5="BLACK" Attribute6="095" Attribute7="24" Attribute8="12" Attribute9="2" Attribute10="A" Attribute11="10074841" />
      </InvoiceLineSet>
     </InvoicePurchaseOrder>

 <InvoicePurchaseOrder PurchaseOrderId="173676" PurchaseOrderNumber="10074842" PurchaseOrderRevision="">
        <InvoiceLineSet Count="1">
          <InvoiceLine InvoiceLineId="85098" ItemType="LINE" LineId="0003" OrderSequence="1" 
                       Key1="173675-A-23040-M-095" ItemDescription="STANDARD" Quantity="24" QuantityUOM="PRS" 
            UnitPrice="18.15" Amount1="435.6" Amount2="" Amount3="" FactoryId="" AdjustedSacLineAmount="" 
            TariffCode="" Attribute1="173675" Attribute2="M" Attribute3="FLORENTINE" Attribute4="23040" 
            Attribute5="BLACK" Attribute6="095" Attribute7="24" Attribute8="12" Attribute9="2" Attribute10="A"
            Attribute11="10074841" />
       </InvoiceLineSet>
      </InvoicePurchaseOrder>
</InvoicePurchaseOrderSet>

samjudson · September 4th, 2008, 07:47 AM

There is no InvoicePurchaseOrderNumber attribute on the InvoiceLine element.

To 'retrieve' an attribute you simply use the "@" symbol before the attribute name, e.g. @InvoiceLineId.

/- Sam Judson : Wrox Technical Editor -/

mhkay · September 4th, 2008, 08:17 AM

If InvoicePurchaseOrderNumber were an attribute of InvoiceLine, you would do

<xsl:template match="InvoicePurchaseOrder">
<xsl:for-each select="InvoiceLine">
  <xsl:value-of select="@InvoicePurchaseOrderNumber"/>
</xsl:for-each>
</xsl:template>

But it isn't, so I don't really know what you want. Perhaps

<xsl:template match="InvoicePurchaseOrder">
  <xsl:variable name="PO-nr" select="@PurchaseOrderNumber"/>
  <xsl:for-each select="InvoiceLine">
    <xsl:value-of select="$PO-Nr"/>
  </xsl:for-each>
</xsl:template>

Michael Kay
http://www.saxonica.com/
Author, XSLT 2.0 and XPath 2.0 Programmer's Reference