Hello all.
I'm using XSLT to display data from an xml file.
Here's a very simplified idea of the format of the XML file
<Practice>
<PracticeName>Practice One</PracticeName>
<Doctor>
<sex>M</sex>
</Doctor>
<Doctor>
<sex>F</sex>
</Doctor>
</Practice>
So a practice can have one or more Doctors, each of which has a sex node. That sounds dirty :)
Anyway. I need to ONLY SHOW A PRACTICE IF IT HAS AT LEAST 1 FEMALE DOCTOR.
I can filter out the Male doctors in a practice, but if there are only male doctors, it still shows the PracticeName. I would like it to completely skip the practice if there are no Females.
Here's pseudocode for what i'm trying to do (and how i'd do it in vb)
for each Practice
for each Doctor
if sex = 'M' then foundmale = true
next
if foundmale = false then
Print Practice
end if
next
Comprendez? I think either a) XSLT cant do what i'm trying to do in which case its crap. or more likely b) I just dont know enough XSLT.
Something along the lines of <xsl:if test="count(sex='M')>0"> is what i'm looking for. But that obviously doesnt work!
Any help is appreciated greatly.
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.
Sorry i should have said - i can't change the format of the XML... it's coming to me from a webservice on a remote machine. i have to work with what i've got.
Also, your code would create too many repeats i think. it looks like it would show this:
Practice One
Doctor One - F
Practice One
Doctor Two - F
Practice One
Doctor Three - F
... see what i mean? it repeats the whole practicename.
its damn hard to explain, all this XML stuff.
Depends on what you do with the code inside the for-each loop. I could show only what I needed for each practice that had a female doctor.
<xsl:for-each select="/Practice/Practice
<p>
<xsl:value-of select="//PracticeName" />
<xsl:for-each select="//Doctor">
<xsl:value-of select="//sex"/>
</xsl:for-each>
</p>
</xsl:for-each>
well thats the general Idea.
string(.) gives string representation of current (specified by ".") node's content.
This is what you want to compare with 'F'.
Doctor/sex - selects all "sex" nodes. Square brackets contains condition what subset to take into consideration.
count() counts.
Outer square brackets contains condition which "Practice" elements to choose.
Thant all!
Business Accounts
Answer for Membership
by: raizonPosted on 2002-09-18 at 08:04:19ID: 7288492
I havn't tested it but take a look at this and see if this gets what you need. Noticed I changed the sex node to an attribute.
<Practice>
<PracticeName>Practice One</PracticeName>
<Doctor sex="M">
</Doctor>
<Doctor sex="F">
</Doctor>
</Practice>
<xsl:for-each select="/Practice/Practice
<!--put your code here -->
</xsl:for-each>