XML Editor
Sign up for a WebBoard account Sign Up Keyword Search Search More Options... Options
Chat Rooms Chat Help Help News News Log in to WebBoard Log in Not Logged in
Conferences Close Tree View
+ Stylus Studio Feature Requests (1192)
+ Stylus Studio Technical Forum (14621)
+ Website Feedback (249)
- XSLT Help and Discussion (7625)
-> + How to add page number in to v... (2)
-> + XSL Grouping (7)
-> + Repeat images using FOR EACH l... (7)
-> + How to get File name (2)
-> + image and text on the same lin... (2)
-> + Create XSLT stylesheets for us... (2)
-> + Merge Multiple Files While Che... (2)
-> + xslt 3 level or multi level gr... (6)
-> + How to create xsl which will c... (2)
-> + xsl:variable and Result Tree F... (7)
-> - XSL-FO fo:table continued from... (1)
-> + XSLT Java issue (2)
-> + problem with hyperlink (4)
-> + substring-after function probl... (4)
-> + Xalan Processing (3)
-> + Memory utilization high with m... (2)
-> + check all parent node groups s... (2)
-> + CSV DOC to XML CONVERSION (11)
-> + XSLT: Ordered List (based on r... (4)
-> + XSLT Mapping - Issue (4)
-> + XSL following-sibling, how to ... (5)
-> + need xslt elements help (2)
-> + Dynamic generation of URL in X... (2)
-> + List Created from Section Navi... (2)
-> + xslt elements help (2)
-> + Map field if source is not nul... (3)
-> + XSLT group and sort whith gene... (4)
-> + Nested XML value (2)
-> + Specifying condition with coun... (4)
-> + xsl:function using found in er... (4)
-> + How to remove an unwanted spac... (2)
-> + Question about variable substi... (2)
-> + XSL for Comparing nodes and di... (4)
-> + External lookup list (8)
-> + XSL HTML output now needs to b... (2)
-> + Adding a new sub element to th... (4)
-> + How do I get rid of 'Tip' node... (9)
-> + Trying to dynamically create n... (2)
-> + Display XML link, using XSLT a... (9)
-> - calling templates based on ord... (2)
-> ->calling templates based o...
-> + How to add internal links usin... (4)
-> + How to call user defined java ... (3)
-> + XSLT and WebApps past and futu... (3)
-> + passing condition through java... (3)
-> + Apllying a template from withi... (4)
-> + Getting xsl element in javascr... (3)
-> + The document() function inside... (3)
-> + Footnote text move to para (2)
-> + XSL: multiple element come to ... (3)
-> + How to use following-sibling &... (2)
-> + How to use FOP 0.95 with Stylu... (4)
-> + Error during creating PDF from... (2)
-> + Help creating a comma delimite... (4)
-> + Selective Add using XSLT recur... (3)
-> + Help: convert without parent e... (2)
-> - Correct my substring function ... (1)
-> + Old xsl into reports (4)
-> + How to save xslt converted fil... (3)
-> + How to find non tagging text? (5)
-> + Help: Hex entity to Character... (6)
-> + EDI QUOTES MESSAGE NEED TO REP... (2)
-> + How to convert in multi level ... (4)
-> + Need some help with a styleshe... (3)
-> - Conditional Formattinf Formula... (1)
-> + Creating HTML Unordered LIsts.... (2)
-> + xslt params uknown number of i... (2)
-> + How to use fonts other than ba... (2)
-> - Converting existing HTML into ... (1)
-> + Help to tune up this XSLT (2)
-> + XSLT - is only converting the ... (2)
-> + XSLT Editor tab (4)
-> + Convert multiple files from XM... (2)
-> + how to use in select expressi... (2)
-> + Help needed in XSL transformat... (2)
-> + How to add a string with math ... (5)
-> + How to add a string with math ... (6)
-> - br element (1)
-> + Stylesheet directed terminatio... (2)
-> + Who can help me whit sum funct... (2)
-> + XSLT Works in Stylus Studio, n... (3)
-> - Filter by Attribute (1)
-> + Display x number of items whic... (6)
-> + MultiColumn Reporting (3)
-> + cant get namespace declaration... (3)
-> + Performance xsl:for each and n... (3)
-> + How to assign value to a XSLT ... (3)
-> + Select element value based on ... (2)
-> + Version 10 of Saxon? (8)
-> + How to get the value of a node... (5)
-> + Display Xpath using (4)
-> + XSLT to report (2)
-> + xslt help for a noobie (2)
-> + XSL-FO XML to PDF with XSLT (3)
-> + Using XSLT to transform XML to... (4)
-> + XSLT to sort a list alphabetic... (4)
-> + How to Get Colum Values based ... (2)
-> + non persisting predicate filte... (5)
-> + HTML to XSLT (2)
-> + extra carriage returns in "csv... (2)
-> + extra carriage returns in "csv... (3)
-- Previous [301-320] [321-340] [341-360] Next
+ XQuery Help and Discussion (2017)
+ Stylus Studio FAQs (159)
+ Stylus Studio Code Samples & Utilities (364)
+ Stylus Studio Announcements (113)
Topic  
Postnext
todd jacksonSubject: calling templates based on order of node sets
Author: todd jackson
Date: 26 May 2009 08:05 PM
Originally Posted: 26 May 2009 07:07 PM
I'm having problems ordering a list of occurrences, for start & end dates, for tertiary courses, based on which campus they are run at.

I can get all the occurences dates for each course listed if I replace the for-each block in the XSLT (see below) and use "<xsl:apply-templates select="COURSEDEFINITION/COURSEOCCURRENCES/COURSEOCCURRENCE"/>" in its place. But it doesn't work when I use the for-each block, and want to order all the dates for courses running under their respective campus?

An example the source xml is :

<COURSES>
<COURSEDEFINITION>
<COURSE_CODE>243.023</COURSE_CODE>
<COURSE_TITLE>Communication Skills</COURSE_TITLE>
<CBD_CATEGORY>Communication</CBD_CATEGORY>
<COURSEOCCURRENCES>
<COURSEOCCURRENCE>
<CAMPUS>Highbrook</CAMPUS>
<ACTIVITYOCCURRENCES>
<ACTIVITYOCCURRENCE>
<ACTIVITY_CODE>243.023-091B-S01-01</ACTIVITY_CODE>
<START_DATE>10/06/2009</START_DATE>
<END_DATE>24/06/2009</END_DATE>
<STATUS>Live</STATUS>
<SUBSTATUS>Running</SUBSTATUS>
<TIMESLOTS>
<TIMESLOT>
<START_TIME>11 June 2009, 09:00:00</START_TIME>
<END_TIME>11 June 2009, 12:00:00</END_TIME>
</TIMESLOT>
</TIMESLOT>
<TIMESLOT>
<START_TIME>24 June 2009, 09:00:00</START_TIME>
<END_TIME>24 June 2009, 12:00:00</END_TIME>
</TIMESLOT>
</TIMESLOTS>
</ACTIVITYOCCURRENCE>
</ACTIVITYOCCURRENCES>
</COURSEOCCURRENCE>
<COURSEOCCURRENCE>
<CAMPUS>Strathbourne</CAMPUS>
<ACTIVITYOCCURRENCES>
<ACTIVITYOCCURRENCE>
<ACTIVITY_CODE>243.023-091B-S01-01</ACTIVITY_CODE>
<TIMESLOTS>
<TIMESLOT>
<START_TIME>10 June 2009, 09:00:00</START_TIME>
<END_TIME>10 June 2009, 12:00:00</END_TIME>
</TIMESLOT>
</ACTIVITYOCCURRENCE>
</ACTIVITYOCCURRENCES>
</COURSEOCCURRENCE>
<COURSEOCCURRENCE>
<CAMPUS>Highbrook</CAMPUS>
<ACTIVITYOCCURRENCES>
<ACTIVITYOCCURRENCE>
<ACTIVITY_CODE>243.023-091B-S01-01</ACTIVITY_CODE>
<TIMESLOTS>
<TIMESLOT>
<START_TIME>10 June 2009, 09:00:00</START_TIME>
<END_TIME>10 June 2009, 12:00:00</END_TIME>
</TIMESLOT>
</ACTIVITYOCCURRENCE>
</ACTIVITYOCCURRENCES>
</COURSEOCCURRENCE>
<COURSEOCCURRENCE>
etc.........

My XSLT is :
....
<p><span class="Subhead3">Date and Times</span></p>
<xsl:for-each select="COURSEDEFINITION/COURSEOCCURRENCES/COURSEOCCURRENCE">
<xsl:choose>
<xsl:when test="contains(string(./CAMPUS)) 'Highbrook')">
<p><strong>Strathbourne</strong></p>
<xsl:apply-templates select="."/>
</xsl:when>
<xsl:when test="contains(string(./CAMPUS)), 'Strathbourne')">
<xsl:apply-templates select="."/>
</xsl:when>
etc..
</xsl:choose>
</xsl:for-each>


<xsl:template match="COURSEOCCURRENCE">
<xsl:if test="((php:function('dateUnixFormated', string(./START_DATE)) >= $currUDate) and ((./TIMETABLE) or (./ACTIVITYOCCURRENCES/ACTIVITYOCCURRENCE//TIMESLOTS/TIMESLOT)))">
<xsl:for-each select="ACTIVITYOCCURRENCES/ACTIVITYOCCURRENCE/TIMESLOTS/TIMESLOT">
<span class="Subhead4"><xsl:value-of select="php:function('date', 'l', php:function('strtotime', substring-before(./START_TIME,',')))"/></span>
etc...
</xsl:for-each>
</xsl:if>

</xsl:template>

Output I want to achieve:

Date and Times

Highbrook

Tuesday 10 June 2009 09:00 - 12:00

Wednesday 11 June 2009 09:00 - 12:00

Thursday 24 June 2009 09:00 - 12:00

Strathbourne

Tuesday 10 June 2009 09:00 - 12:00


etc..

Hope someone can help with my noobie XSLT skills!

Cheers

Posttop
James DurningSubject: calling templates based on order of node sets
Author: James Durning
Date: 27 May 2009 01:27 PM
Muenchian grouping:
List of all campuses:
/COURSES/COURSEDEFINITION/COURSEOCCURENCE/CAMPUS

Get all unique instances:
<xsl:for-each select="/COURSES/COURSEDEFINITION/COURSEOCCURENCE/CAMPUS[not(.=preceding::CAMPUS)]">
Campus: <xsl:value-of select="."/>

Now, inside this for-loop, find all the COURSEDEFINITIONS that take place on this campus. Use current() to get the value of the current node.
<xsl:for-each select="/COURSES/COURSEDEFINITION[COURSEOCCURENCE/CAMPUS = current()]">
...
Output the relevant date information here.

</xsl:for-each>
</xsl:for-each>


Also in the future, please post the end tags at the end of your xml, so your code sample is well-formed xml.

   
Download A Free Trial of Stylus Studio 6 XML Professional Edition Today! Powered by Stylus Studio, the world's leading XML IDE for XML, XSLT, XQuery, XML Schema, DTD, XPath, WSDL, XHTML, SQL/XML, and XML Mapping!  
go

Log In Options

Site Map | Privacy Policy | Terms of Use | Trademarks
Stylus Scoop XML Newsletter:
W3C Member
Stylus Studio® and DataDirect XQuery ™are from DataDirect Technologies, is a registered trademark of Progress Software Corporation, in the U.S. and other countries. © 2004-2016 All Rights Reserved.