<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,

[Dormilich]

I understand it so, that the count of <tag1> has to be now less than 3 if any <subelem1> is > 60 (although this will kill the condition <tag1> = <elem1>). so it should be an easier expression now.

<xsl:if test="count(//subelem1[. &gt; 60]) and count(//tag1) &gt; 2">
  <xsl:message terminate="yes">
  <xsl:text>Only 2 tags are allowed for tag1</xsl:text>
</xsl:if>

please correct me, if my understanding of the conditions is wrong

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.

I don't think this will work in the intended way since [expression] will always return true or false.

regards

[jkmyoung]

Edited above message after Dormilich's comment.

[Dormilich]

still the question remains, if the condition <tag1> = <elem1> must be fulfilled. unfortunately, that's not clear from the actual question. (this was the case for the original question)

[njsimha]

Hi young,
Thanks for the mail.
The explanation you gave seems to be logically perfect but when I executed this,I am encountering an error saying the "XPath error : Invalid expression"

Please suggest me.

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>
 
 

[njsimha]

Hi Dormilich,
what you said is correct.The condition <tag1> = <elem1> has also to be fulfilled.

To make more clear on my question:
In the XML code mentioned in comment # 9:
a) There are 2 <type1> tags whose <tag1> value = <elem1> (that is 1000)
b) There are 2 <type1> tags whose <tag1> value = <elem1> (that is 2000)
Individual count is 2 where as the combined count is 4(error has to be thrown for this also as the total count is greater than 2)

In both the above cases <subelem1> is greater than 60 for each <template1> under which the <elem1> is 1000,2000.

Now the requirement is :
The error has to be thrown in two cases:
1.If the count of all the <tag1> = <elem1> and <subelem1 > 60 is greater than 2

2.If the total count of all the sets meeting the above criteria is greater than 2.

According to the code mentioned in comment # 9,if I add one more <type1> with <tag1> =1000,it throws error saying only 2 tags are allowed for <tag1> = <elem1> where as there are already 4 <type1> tags whose <tag1>= <elem1> but with different <subelem1> values >60.

I guess I made my question clearly.

Thanks,

still the question remains, if the condition <tag1> = <elem1> must be fulfilled. unfortunately, that's not clear from the actual question. (this was the case for the original question)

[Dormilich]

Now the requirement is :
The error has to be thrown in two cases:
1.If the count of all the <tag1> = <elem1> and <subelem1> > 60 is greater than 2

2.If the total count of all the sets meeting the above criteria is greater than 2.

wouldn't the 2nd requirement always include the 1st one (thus making it obsolete)?

The explanation you gave seems to be logically perfect but when I executed this,I am encountering an error saying the "XPath error : Invalid expression"

couldn't verify that, the expression was working perfectly, when I tried it.

regards

[njsimha]

Hi,
It worked well.

Thanks for your help.

wouldn't the 2nd requirement always include the 1st one (thus making it obsolete)?

couldn't verify that, the expression was working perfectly, when I tried it.

regards