Hi,

I have some requirement which is explained below.

The input XML is something like:

<item>
    <body>
        <blocks>
            <block>
                <userDefinedFields>
                    <userDefinedField>
                        <fieldLabel>KOBAR</fieldLabel>
                        <fieldDisplayLabel>Global KO</fieldDisplayLabel>
                        <fieldValue>0</fieldValue>
                        <fieldType>numeric</fieldType>
                    </userDefinedField>
                    <userDefinedField>
                        <fieldLabel>KIBAR</fieldLabel>
                        <fieldDisplayLabel>Global KI</fieldDisplayLabel>
                        <fieldValue>50</fieldValue>
                        <fieldType>numeric</fieldType>
                    </userDefinedField>
                    <userDefinedField>
                        <fieldLabel>BSWP</fieldLabel>
                        <fieldDisplayLabel>Global SW</fieldDisplayLabel>
                        <fieldValue>1</fieldValue>
                        <fieldType>integer</fieldType>
                    </userDefinedField>
                </userDefinedFields>
                <otherFields>
                    <otherField/>
                </otherFields>
                <userDefinedFields>
                    <userDefinedField>
                        <fieldLabel>EXCLN</fieldLabel>
                        <fieldDisplayLabel>Exclude N</fieldDisplayLabel>
                        <fieldValue>1</fieldValue>
                        <fieldType>integer</fieldType>
                    </userDefinedField>
                    <userDefinedField>
                        <fieldLabel>ASTDT</fieldLabel>
                        <fieldDisplayLabel>Start</fieldDisplayLabel>
                        <fieldValue>25</fieldValue>
                        <fieldType>integer</fieldType>
                    </userDefinedField>
                </userDefinedFields>
            </block>
        </blocks>
    </body>
</item>

Requirement:

If the 'userDefinedField' with 'fieldLabel' BSWP exists, then pick the 'fieldValue' of 'userDefinedField' with 'fieldLabel' ASTDT

XSL Code:

I tried with the below shown XSL, but it's not giving the desired output. Can anybody please help if something is going wrong in the code. Thanks for your time.

<xsl:stylesheet xmlns:xsl="http://www.w3.org/1999/XSL/Transform" version="1.0">
    <xsl:template match="/">
        <xsl:apply-templates select="item/body/blocks/block/userDefinedFields/userDefinedField" />
    </xsl:template>
    <xsl:template match="userDefinedField">
        <xsl:if test="./fieldLabel='BSWP'">
            <xsl:value-of select="self::node[fieldLabel='ASTDT']/fieldValue" />
        </xsl:if>
    </xsl:template>
</xsl:stylesheet>

My idea in writing the above code is: as we are inside the template matching 'userDefinedField', I am checking for fieldLabel=BSWP and if it exists then pick the 'fieldValue' where fieldLabel=ASTDT. But this code is returning blank value.

Can you provide the expected output code for the above example XML

I just to want to check the mentioned condition. If the condition is not satisfied then I will just populate zero. I am just looking for the plain value output. This value will be used in the application for further processing.
Thank you.

Requirement:

If the 'userDefinedField' with 'fieldLabel' BSWP exists, then pick the 'fieldValue' of 'userDefinedField' with 'fieldLabel' ASTDT

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.