<Need Help>How to throw an error based on node count in XSLT?

[njsimha]

Hi,
I have the following XML snippet:

<root>
 
<template1>
<elem1>1000</elem1>
<elem2>
    <subelem1>65</subelem1>
</elem2>
 </template1>
 
<template1>
<elem1>2000</elem1>
<elem2>
<subelem1>45</subelem1>
</elem2>
</template1>
 
<template2>
<type1>
 <tag1>1000</tag1>
</type1>
 
<type1>
<tag1>1000</tag1>
</type1>
 
<type1>
<tag1>1000</tag1>
</type1>
 
<type1>
 <tag1>2000</tag1>
 </type1>
 
<type1>
<tag1>2000</tag1>
</type1>
 
<type1>
<tag1>2000</tag1>
</type1>
 
</template2>
</root>
 
 

In the above code,there are 3 <tag1> elements whose value is 1000 and 3 <tag1> elements whose value is 2000.
The value of subelem1 = 65(for which the elem1 is 1000)
The value of subelem1 = 45(for which the elem1 is 2000)

Now the requirement is:
1.There should be only 2 <tag1> elements if subelem1 >60(in this case we have to get the subelem1 value by comparing the <tag1>=<elem1>. Here it is 1000).otherwise error has to be thrown.

2.There should be only 1 <tag1> element if subelem1 <60(in this case we have to get the subelem1 value by comparing the <tag1>=<elem1>. Here it is 2000).otherwise error has to be thrown.

Using your XSLT code that you replied to my previous question,when i print the count in error message it is giving the total count as 6 where as we have to get the count as 3 for <tag1>=1000

Please help me,how can we do the above requirement.

Thanks,

[jkmyoung]

Can you post the previous code?
It's probably as easy as adding a condition[elem1=$value]

[njsimha]

Hi Young,
I tried the following code:

<xsl:variable name="rules" select="count(/template2/type1[tag1 = /template1/elem1])"/>
<xsl:if test="/template1/elem2/subelem1 >60 and $rules >2">
<xsl:message terminate="yes">
<xsl:value-of select="concat("Only 2 tags are allowed for tag1 =1000")/>
</xsl:if>
</xsl:if>
 

The problem with this code is it is giving the total count for variable rules as 6 where as we have to get the count as 3 for <tag1>=1000.T he condition to evaluate rules is selecting all the <tag1> nodes and giving count as 6.How to solve this?

Also please note that there will be 10 <template1> nodes.I have to check across all <template1> tags.

Thanks,

[jkmyoung]

Assuming you're in template:
<xsl:template match="/root/template1/elem1/subelem1">
The value you want for each one is in relative path: ../../elem1

<xsl:variable name="elem1" select="../../elem1"/>
<xsl:variable name="rules" select="count(/template2/type1[tag1 = $elem1])"/>
.......
<xsl:value-of select="concat('Only 2 tags are allowed for tag1 =',$elem1)"/>
 

[njsimha]

Hi Young,
Do you mean to say :

<xsl:template match="/root/template1/elem1/subelem1[. &gt; 60]">
<xsl:variable name="elem1" select="../../elem1"/>
<xsl:variable name="rules" select="count(/template2/type1[tag1 = $elem1])"/>
<xsl:if test="$rules &gt; 2">
<xsl:message terminate="yes">
<xsl:value-of select="concat("Only 2 tags are allowed for tag1 = ', $elem1)")/>
</xsl:if>
</xsl:template>
 

The above code is not working.
In the template match we have to select all <template1> whose <subelem1> value is > 60,so i changed the template match.is it ok?
whatelse has to be changed in the above code to make it working?

Thanks,

Assuming you're in template:
<xsl:template match="/root/template1/elem1/subelem1">
The value you want for each one is in relative path: ../../elem1

<xsl:variable name="elem1" select="../../elem1"/>
<xsl:variable name="rules" select="count(/template2/type1[tag1 = $elem1])"/>
.......
<xsl:value-of select="concat('Only 2 tags are allowed for tag1 =',$elem1)"/>
 

[Dormilich]

<xsl:template match="/root/template1/elem1/subelem1[. &gt; 60]">
<xsl:variable name="elem1" select="../../elem1"/>
<xsl:variable name="rules" select="count(/template2/type1[tag1 = $elem1])"/>
<xsl:if test="$rules &gt; 2">
<xsl:message terminate="yes">
<xsl:value-of select="concat("Only 2 tags are allowed for tag1 = ', $elem1)")/>
</xsl:if>
</xsl:template>
 

The above code is not working.
In the template match we have to select all <template1> whose <subelem1> value is > 60,so i changed the template match.is it ok?
whatelse has to be changed in the above code to make it working?

line #1: "//template1[elem2/subelem1 &gt; 60]" (ok I shifted the condition a bit, but that's only to look better... adjust $elem1 accordingly)

in the above code you're not selecting <template1> but <subelem1>

line #3: /root/template2/type1[tag1 = $elem1] or //template2/type1[tag1 = $elem1]

line #5: element not closed

line #6: typing mistake, 2nd quotation mark must be ' not "

regards

[njsimha]

Hi Dormilich,
Thanks a lot.Its working perfectly.

line #1: "//template1[elem2/subelem1 &gt; 60]" (ok I shifted the condition a bit, but that's only to look better... adjust $elem1 accordingly)

in the above code you're not selecting <template1> but <subelem1>

line #3: /root/template2/type1[tag1 = $elem1] or //template2/type1[tag1 = $elem1]

line #5: element not closed

line #6: typing mistake, 2nd quotation mark must be ' not "

regards

[Dormilich]

glad I could be of help

[njsimha]

Hi Dormilich,

The following is the code you suggested for my question:

<xsl:template match="/root/template1[elem2/subelem1 &gt; 60]">
<xsl:variable name="elem1" select="elem1"/>
<xsl:variable name="rules" select="count(/root/template2/type1[tag1 = $elem1])"/>
<xsl:if test="$rules &gt; 2">
<xsl:message terminate="yes" >
<xsl:value-of select="concat( "Only 2 tags are allowed for tag1 = ', $elem1)')/>
</xsl:if>
</xsl:template>

It is working fine but in one scenario this is not working.I changed 45 to 75 value for subelem1.The $rules in the code is selecting the count for each subelem1 but I want to throw the error if the count is > 2 for all the subelem1 whose value is > 60.Please note that there can be any number of <template1> tags.

In the following code,(according to your code) it works fine as there are only two <tag1> tags for each subelem1 but I want to throw error after combining the count for all the <subelem1> tags whose value is > 60.

So it has to throw error for the following input saying that "The combined total count is 4.Only 2 <tag1> are allowed under <template2>"

<root>
 
<template1>
<elem1>1000</elem1>
<elem2>
    <subelem1>65</subelem1>
</elem2>
 </template1>
 
<template1>
<elem1>2000</elem1>
<elem2>
<subelem1>75</subelem1>
</elem2>
</template1>
 
<template2>
<type1>
 <tag1>1000</tag1>
</type1>
 
<type1>
<tag1>1000</tag1>
</type1>
 
<type1>
 <tag1>2000</tag1>
</type1>
 
<type1>
 <tag1>2000</tag1>
</type1>
 
</template2>
 

Please help me in adding this extra check for the code you suggested.
Thanks.

glad I could be of help

[jkmyoung]

Xpath for values (>60?) you're looking at is /root/template1/elem2/subelem1

Find all the template 1 nodes with that value > 60
/root/template1[elem2/subelem1 &gt; 60]

Now we find each of the indexes for these values > 60, eg the elem1 node.
/root/template1[elem2/subelem1 &gt; 60]/elem1

general xpath for type1's tag1 values.
/root/template2/type1/tag1

The ones meeting the criteria are:
(/root/template2/type1/tag1[/root/template1[elem2/subelem1 &gt; 60]/elem1 = .]
In other words, there exists a template1 node with subelem1 > 60, such that the elem1 node equals the current tag1 node.

Putting it together, it should look like:

<xsl:template match="/root">
    <xsl:if test="count(/root/template2/type1/tag1[/root/template1[elem2/subelem1 &gt; 60]/elem1 = .] ) &gt; 2">
        <xsl:message terminate="yes">
            <xsl:value-of select="'Only 2 tags are allowed for tag1 &gt; 60 '"/>
        </xsl:message>
    </xsl:if>
</xsl:template>