I am writing a simple report given an XML file that is a fax log. In each fax, there is a job code, and I want to give a summary of counts by job code. I cannot figure out how to write that -- all I can manage is a total for all faxes.
Here's a sample of the log entries:
- <xml>
- <fax>
<job_id>99999998</job_id>
<job_code>123</job_code>
<fax_number>5551212</fax_n
<sender>xxxxxxxx</sender>
<status>Successful</status
<pages>1</pages>
<duration>42</duration>
<fax_timestamp>2005-01-01 17:00:00</fax_timestamp>
</fax>
- <fax>
<job_id>99999999</job_id>
<job_code>456</job_code>
<fax_number>5551212</fax_n
<sender>xxxxxxxx</sender>
<status>Successful</status
<pages>1</pages>
<duration>42</duration>
<fax_timestamp>2005-01-01 18:00:00</fax_timestamp>
</fax>
</xml>
I want to be able to show a count of 1 for job code 123 and a count of 1 for job code 456. All I have been able to get to work so far is this:
<xsl:value-of select="count(//job_code)"
which just gives me the total count of 2.
So how do I get to where I can show a total for each job code in the log?
Thanks!
This Question has been solved and asker verified All Experts Exchange premium technology solutions are available to subscription members.
Experts Exchange has been collecting answers to technology questions since 1996…3 million and counting! If you have a question, chances are we already have your answer.
If you can't find the exact answer you're looking for, ask our exclusive community of 50,000 experts. You’ll get a personalized answer from a trusted professional.
Thousands of free tech tips, tricks, how-to’s and tutorials are available in our peer reviewed articles section. See for yourself how smart our experts are, no login required.
Save solutions to your questions, answers you’ve discovered through searching plus helpful articles in your personal knowledgebase for easy future access.
Access the answers to your technology questions today.
30-day free trial. Register in 60 seconds.
Members of the expert community talk about why the experience at Experts Exchange is different than what you will find anywhere else.
Try it out and discover for yourself.
30-day free trial. Register in 60 seconds.
Join the community of experts here and help other tech pros by answering question in your area of expertise. You can earn FREE access to all Experts Exchange's premium features and resources.
This syntax works staticly, as you suggest -- thanks. But since I don't know what the job code are going to be, I need to figure out how to do this based on whatever the log contains, which can be different every time. I assume that means that I need to put this code in the for-each loop, but how do I dynamically refer to each job code?
Thanks!
oh...yeah, i forgot current() - to reference current iterating node:
<?xml version="1.0" encoding="UTF-8"?>
<xsl:stylesheet version="1.0" xmlns:xsl="http://www.w3.o
<xsl:output method="xml" version="1.0" encoding="UTF-8" indent="yes"/>
<xsl:template match="/">
<xsl:for-each select="/xml/fax">
JobID:<xsl:value-of select="job_id" /><br/>
JobCode: <xsl:value-of select="job_code" /><br/>
Total jobs with the same code: <xsl:value-of select="count(//job_code[.
</xsl:for-each>
</xsl:template>
</xsl:stylesheet>
Business Accounts
Answer for Membership
by: dualsoulPosted on 2005-01-30 at 03:26:53ID: 13175396
Add predicate in [] to indicate particular conditions. You can specify it dynamicly in for-each loop, or staticly as in example below:
<xsl:value-of select="count(//job_code[.
<xsl:value-of select="count(//job_code[.