RE: [xsl] Total Missing documents for each Event
2010-04-26 13:03:32
Got it..
In the function I should have done
<xsl:sequence
select="count($x[not(.=$event/document_type/@sp_document_type)])"/>
I was not matching my context with the current event.
Thanks for looking...
Shashank
----------------------------------------
From: shashankjain(_at_)live(_dot_)com
To: xsl-list(_at_)lists(_dot_)mulberrytech(_dot_)com
CC: davidc(_at_)nag(_dot_)co(_dot_)uk
Date: Mon, 26 Apr 2010 12:01:58 -0500
Subject: RE: [xsl] Total Missing documents for each Event
(Sending it again, removed the extra spaces in the code)
Hello All,
I am trying to calculate the Sum of total Missing Docs.
Here is my XML:
Previously I used following template to calculate number of missing
events, thanks to David for that.
--
select="tokenize(parent::node()/@sp_mand_doctypes,'\s*,\s*')"/>
select="count($x[not(.=current()/document_type/@sp_document_type)])"/>
I got the required output 5,4,6,3,2.
Now I am trying to add all those values and for that I am using this
function, so I want the total to be 5+4+6+3+2=20
select="tokenize($event/../@sp_mand_doctypes,'\s*,\s*')"/>
select="count($x[not($event/document_type/@sp_document_type)])"/>
And calling this function in this way
I am not able to get the desired output. Looks like Function is not
calculating the value at each event properly. Please correct me where
I am doing it wrong.
Thanks
Shashank
----------------------------------------
From: shashankjain(_at_)live(_dot_)com
To: xsl-list(_at_)lists(_dot_)mulberrytech(_dot_)com
CC: davidc(_at_)nag(_dot_)co(_dot_)uk
Date: Mon, 26 Apr 2010 11:51:19 -0500
Subject: RE: [xsl] Total Missing documents for each Event
Hello All,
I am trying to calculate the Sum of total Missing Docs.
Here is my XML:
Previously I used following template to calculate number
of missing events, thanks to David for that.
select="event">
name="NumDocumentsMissing"/>
test="@complete='Y'">
--
name="x"
select="tokenize(parent::node()/@sp_mand_doctypes,'\s*,\s*')"/>
select="count($x[not(.=current()/document_type/@sp_document_type)])"/>
I got the required output 5,4,6,3,2.
Now I am trying to add all those values and for that I am
using this function, so I want the total to be 5+4+6+3+2=20
name="event" as="element()"/>
test="$event/@complete='Y'">
select="0"/>
select="tokenize($event/../@sp_mand_doctypes,'\s*,\s*')"/>
select="count($x[not($event/document_type/@sp_document_type)])"/>
And calling this function in this way
I am not able to get the desired output. Looks like
Function is not calculating the value at each event properly. Please correct
me
where I am doing it wrong.
Thanks
Shashank
From: shashankjain(_at_)live(_dot_)com
To: xsl-list(_at_)lists(_dot_)mulberrytech(_dot_)com
CC: davidc(_at_)nag(_dot_)co(_dot_)uk
Date: Fri, 9 Apr 2010 11:35:27 -0500
Subject: RE: [xsl] Total Missing documents for each Event
Thanks David !
You understood my requirement very well, this is exactly what I wanted.
I agree my code is vastly complicated , I will work on it to write more
efficient code.
Thanks again.
Shashank
----------------------------------------
Date: Fri, 9 Apr 2010 17:00:02 +0100
From: davidc(_at_)nag(_dot_)co(_dot_)uk
To: shashankjain(_at_)live(_dot_)com
CC: xsl-list(_at_)lists(_dot_)mulberrytech(_dot_)com
Subject: Re: [xsl] Total Missing documents for each Event
Either I'm not understanding your requirements or your code is vastly
more complicated than needed (or both)
i think you just want
xmlns:xsl="http://www.w3.org/1999/XSL/Transform">
select="tokenize(@sp_mand_doctypes,'\s*,\s*')"/>
For event
list is:
select="$x[not(.=current()/document_type/@sp_document_type)]"
separator=","/>
count
select="count($x[not(.=current()/document_type/@sp_document_type)])"/>
additional docs:
select="document_type/@sp_document_type[not(.=$x)]"
separator=","/>
count
which makes
$ saxon9 list.xml list.xsl
For event 1
list is: PSC Minutes,Internal Approval,Rationale,Trade
Instructions,IPS count 5
additional docs: count 0
For event 2
list is: PSC Minutes,Internal Approval,Trade Instructions,IPS count 4
additional docs: count 0
For event 3
list is: PSC Minutes,Internal Approval,Rationale,Trade
Instructions,IPS,Final Client Models count 6
additional docs: Analyst count 1
________________________________________________________________________
The Numerical Algorithms Group Ltd is a company registered in England
and Wales with company number 1249803. The registered office is:
Wilkinson House, Jordan Hill Road, Oxford OX2 8DR, United Kingdom.
This e-mail has been scanned for all viruses by Star. The service is
powered by MessageLabs.
________________________________________________________________________
--~------------------------------------------------------------------
XSL-List info and archive: http://www.mulberrytech.com/xsl/xsl-list
To unsubscribe, go to: http://lists.mulberrytech.com/xsl-list/
or e-mail:
--~--
_________________________________________________________________
The New Busy is not the too busy. Combine all your e-mail accounts with
Hotmail.
http://www.windowslive.com/campaign/thenewbusy?tile=multiaccount&ocid=PID28326::T:WLMTAGL:ON:WL:en-US:WM_HMP:042010_4
--~------------------------------------------------------------------
XSL-List info and archive: http://www.mulberrytech.com/xsl/xsl-list
To unsubscribe, go to: http://lists.mulberrytech.com/xsl-list/
or e-mail:
--~--
_________________________________________________________________
The New Busy is not the old busy. Search, chat and e-mail from your inbox.
http://www.windowslive.com/campaign/thenewbusy?ocid=PID28326::T:WLMTAGL:ON:WL:en-US:WM_HMP:042010_3
--~------------------------------------------------------------------
XSL-List info and archive: http://www.mulberrytech.com/xsl/xsl-list
To unsubscribe, go to: http://lists.mulberrytech.com/xsl-list/
or e-mail:
--~--
_________________________________________________________________
The New Busy is not the old busy. Search, chat and e-mail from your inbox.
http://www.windowslive.com/campaign/thenewbusy?ocid=PID28326::T:WLMTAGL:ON:WL:en-US:WM_HMP:042010_3
--~------------------------------------------------------------------
XSL-List info and archive: http://www.mulberrytech.com/xsl/xsl-list
To unsubscribe, go to: http://lists.mulberrytech.com/xsl-list/
or e-mail:
--~--
_________________________________________________________________
The New Busy think 9 to 5 is a cute idea. Combine multiple calendars with
Hotmail.
http://www.windowslive.com/campaign/thenewbusy?tile=multicalendar&ocid=PID28326::T:WLMTAGL:ON:WL:en-US:WM_HMP:042010_5
--~------------------------------------------------------------------
XSL-List info and archive: http://www.mulberrytech.com/xsl/xsl-list
To unsubscribe, go to: http://lists.mulberrytech.com/xsl-list/
or e-mail: <mailto:xsl-list-unsubscribe(_at_)lists(_dot_)mulberrytech(_dot_)com>
--~--
|
|