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
Show tree view Topic
Topic Page 1 2 3 4 5 6 7 8 9 Go to previous topicPrev TopicGo to next topicNext Topic
Postnext
Neha AgarwalSubject: Compare
Author: Neha Agarwal
Date: 24 Jul 2008 06:18 AM
My xml contains the reords of an employee shift and it's task. so it might be possible that one employee in one has to do many task. so my xml contains the reords as:
<Detail>
<idShiftNo>72</idShiftNo>
<idEmployee>221265</idEmployee>
<NameEmployee>Biswal, Antje</NameEmployee>
<Date>2007-01-05T00:00:00+05:30</Date>
<Department>1</Department>
<ShiftName>F11</ShiftName>
<ShiftStart>2007-01-05T02:30:00+05:30</ShiftStart>
<ShiftEnd>2007-01-05T11:00:00+05:30</ShiftEnd>
<idTaskNo>324</idTaskNo>
<strNameJob>C-DE</strNameJob>
<idTaskNo1>324</idTaskNo1>
<TaskStart>2007-01-05T02:30:00+05:30</TaskStart>
<TaskEnd>2007-01-05T04:15:00+05:30</TaskEnd>
<TaskName>C-DE5824</TaskName>
<fontColorHTML>#000000</fontColorHTML>
<backColorHTML>#C0C0C0</backColorHTML>
<ToolTip>Flight: Job: C-DE Task:C-DE5824 STA: STD: 03:45 AcOP: DE AcType: 320 Dest: TFS

PaxMax: 174 PaxBkd: 176</ToolTip>
</Detail>
<Detail>
<idShiftNo>72</idShiftNo>
<idEmployee>221265</idEmployee>
<NameEmployee>Biswal, Antje</NameEmployee>
<Date>2007-01-05T00:00:00+05:30</Date>
<Department>1</Department>
<ShiftName>F11</ShiftName>
<ShiftStart>2007-01-05T02:30:00+05:30</ShiftStart>
<ShiftEnd>2007-01-05T11:00:00+05:30</ShiftEnd>
<idTaskNo>292</idTaskNo>
<strNameJob>BO</strNameJob>
<idTaskNo1>292</idTaskNo1>
<TaskStart>2007-01-05T04:15:00+05:30</TaskStart>
<TaskEnd>2007-01-05T04:55:00+05:30</TaskEnd>
<TaskName>DE5824</TaskName>
<fontColorHTML>#000000</fontColorHTML>
<backColorHTML>#C0C0C0</backColorHTML>
<ToolTip>Flight: Job: BO Task:DE5824 STA: STD: 03:45 AcOP: DE AcType: 320 Dest: TFS PaxMax:

174 PaxBkd: 176</ToolTip>
</Detail>
<Detail>
<idShiftNo>72</idShiftNo>
<idEmployee>221265</idEmployee>
<NameEmployee>Biswal, Antje</NameEmployee>
<Date>2007-01-05T00:00:00+05:30</Date>
<Department>1</Department>
<ShiftName>F11</ShiftName>
<ShiftStart>2007-01-05T02:30:00+05:30</ShiftStart>
<ShiftEnd>2007-01-05T11:00:00+05:30</ShiftEnd>
<idTaskNo>296</idTaskNo>
<strNameJob>BO</strNameJob>
<idTaskNo1>296</idTaskNo1>
<TaskStart>2007-01-05T06:25:00+05:30</TaskStart>
<TaskEnd>2007-01-05T06:55:00+05:30</TaskEnd>
<TaskName>C91680</TaskName>
<fontColorHTML>#000000</fontColorHTML>
<backColorHTML>#C0C0C0</backColorHTML>
<ToolTip>Flight: Job: BO Task:C91680 STA: STD: 05:55 AcOP: C9 AcType: D38 Dest: ZRH PaxMax: 33 PaxBkd: 20</ToolTip>
</Detail>
<Detail>
<idShiftNo>72</idShiftNo>
<idEmployee>221265</idEmployee>
<NameEmployee>Biswal, Antje</NameEmployee>
<Date>2007-01-05T00:00:00+05:30</Date>
<Department>1</Department>
<ShiftName>F11</ShiftName>
<ShiftStart>2007-01-05T02:30:00+05:30</ShiftStart>
<ShiftEnd>2007-01-05T11:00:00+05:30</ShiftEnd>
<idTaskNo>428</idTaskNo>
<strNameJob>CKI-F</strNameJob>
<idTaskNo1>428</idTaskNo1>
<TaskStart>2007-01-05T07:00:00+05:30</TaskStart>
<TaskEnd>2007-01-05T08:15:00+05:30</TaskEnd>
<TaskName>CKI-F</TaskName>
<fontColorHTML>#000000</fontColorHTML>
<backColorHTML>#C0C0C0</backColorHTML>
<ToolTip>RoutineJob:CKI-F Task:CKI-F Start: 07:00 End: 08:15</ToolTip>
</Detail>
</NewDataSet>

xslt is:

<?xml version="1.0" encoding="iso-8859-1"?>
<xsl:stylesheet version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform">


<xsl:key name="distinctShift" match="NewDataSet/Detail" use="./idShiftNo"/>

<xsl:template match="/">

<table>

<xsl:for-each select="NewDataSet/Detail[generate-id() = generate-id(key('distinctShift', ./idShiftNo)[1])]">
<tr>
<td>
<xsl:value-of select="idShiftNo"/>
</td>
<td>
<xsl:value-of select="ShiftName"/>
</td>
<td>
<xsl:for-each select="/NewDataSet/Detail[idShiftNo = current()/idShiftNo]">
<xsl:if test="position() != 1">,</xsl:if>
<xsl:value-of select="idTaskNo"/>
</xsl:for-each>
</td>
</tr>
</xsl:for-each>
</table>
</xsl:template>

</xsl:stylesheet>


The problem is that as i have to show this on a chart then there it shows as


but i wan't to show it like
72 Biswal, Antje shiftstarttime shiftendtime task1 task2

m able to show it like that one problem is there i wan't to compare the current TaskStart to the previous TaskStart.
How m able to do that???
Help m in this .

Posttop
Tony LavinioSubject: Compare
Author: Tony Lavinio
Date: 24 Jul 2008 11:59 AM
Please, first, which version of Stylus Studio are you using,
and within it, which XSLT processor?

 
Topic Page 1 2 3 4 5 6 7 8 9 Go to previous topicPrev TopicGo to next topicNext Topic
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.