Multiple joins in XSLT - major confusion

Dev Shed Forums Sponsor:

April 21st, 2011, 11:19 AM

craigj

Contributing User

Join Date: Apr 2003

Location: Scotland, 55n53, 4w15

Posts: 156

Time spent in forums: 1 Day 7 h 27 m 7 sec
Reputation Power: 57

Multiple joins in XSLT - major confusion

My source XML is:

Code:

<Data>

    <YogaClass courseId="A" endDate="April"/>
    <YogaClass courseId="B" endDate="April"/>
    <YogaClass courseId="C" endDate="July"/>

    <Session courseId="A">
        <Recruit id="1" attended="yes"/>
        <Recruit id="2" attended="yes"/>
        <Recruit id="3" attended="no"/>
        <Recruit id="4" attended="yes"/>
    </Session>

    <Session courseId="A">
        <Recruit id="1" attended="yes"/>
        <Recruit id="2" attended="yes"/>
        <Recruit id="3" attended="no"/>
        <Recruit id="4" attended="yes"/>
    </Session>

    <Session courseId="B">
        <Recruit id="5" attended="yes"/>
        <Recruit id="6" attended="yes"/>
        <Recruit id="7" attended="no"/>
    </Session>

    <Session courseId="C">
        <Recruit id="8" attended="yes"/>
        <Recruit id="9" attended="yes"/>
        <Recruit id="10" attended="no"/>
        <Recruit id="11" attended="yes"/>
    </Session>

    <Recruit id="1" gender="Male" />
    <Recruit id="2" gender="Female" />
    <Recruit id="3" gender="Female" />
    <Recruit id="4" gender="Female" />
    <Recruit id="5" gender="Male" />
    <Recruit id="6" gender="Female" />
    <Recruit id="7" gender="Female" />
    <Recruit id="8" gender="Female" />
    <Recruit id="9" gender="Male" />
    <Recruit id="10" gender="Female" />
    <Recruit id="11" gender="Female" />

</Data>

I want to work out:

The number of male recruits who attended at least 50% of sessions for any yoga course ending in April'.

But I just can't get my head around how to do all the joins. Is this possible in XSLT?

Last edited by craigj : April 21st, 2011 at 11:24 AM.

April 21st, 2011, 12:08 PM

requinix

Still alive

Join Date: Mar 2007

Location: Washington, USA

Posts: 12,703

Folding Points: 417516 Folding Title: Super Ultimate Folder - Level 1

Time spent in forums: 5 Months 1 Week 4 Days 5 h 39 m 40 sec
Reputation Power: 8969

Send a message via Google Talk to requinix

You can't really do JOINs, but you can search for nodes that match a condition.

Task for you:
If you were to manually calculate the answer, how would you do it?

__________________
Site rules and FAQ | Project Suggestions | mod_rewrite guide | PHP New User Guide and FAQ - PHP Stickies | Regex Resources

Viewing: Dev Shed Forums > Programming Languages - More > XML Programming > Multiple joins in XSLT - major confusion

« Previous Thread | Next Thread »

Developer Shed Advertisers and Affiliates

Thread Tools	Search this Thread
Email this Page	Search this Thread: Advanced Search
Display Modes	Rate This Thread
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode	Rate This Thread:

Posting Rules
You may not post new threads You may not post replies You may not post attachments You may not edit your posts vB code is On Smilies are On [IMG] code is On HTML code is Off

View Your Warnings | New Posts | Latest News | Latest Threads | Shoutbox

Forum Jump