How do I get one result back instead of multiple results?

winkimjr2 · June 3rd, 2014, 04:25 PM

I have a xml document which has 2 Service information elements. When I run my xsl , I only want to see one Deleted notification
<NotificationEvent>Deleted</NofiticationEvent> instead of two.

Here is the result with two NotificationEvents.

Code:

<?xml version="1.0" encoding="UTF-8"?>
<NotificationEvent xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:fn="http://www.w3.org/2005/xpath-functions" notificationType="ProtectionOrderService" elementKey="1200" servedByWord="KL0820700" servedByText="Grove Police Department" dateServed="03/25/2014" timeServed="10:00 AM" howServedWord="PERSON" howServedText="In-Person" whoWasServedInternalId="704607705">Deleted</NotificationEvent>

<NotificationEvent xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:fn="http://www.w3.org/2005/xpath-functions" notificationType="ProtectionOrderService" elementKey="1200" servedByWord="GN0170000" servedByText="County Sheriff's Office" dateServed="03/24/2014" timeServed="8:00 PM" howServedWord="SHORTFORM" howServedText="Short Form" whoWasServedInternalId="704607705">Deleted</NotificationEvent>

XSL should check if the <ServiceInfo> element has an Op="A" or "E" or "D". If it finds one or more of these, the output should be only one message. In my case I am getting two messages because there are two elements with <ServiceInfo Op="D">

Here is my xml

Code:

<ServicesInfo>
          <ServiceInfo Op="D">	     						     <ServedBy Op="D" Word="KL0820700">Grove Police Department</ServedBy>
	 <DateServed Op="D">03/25/2014</DateServed>
	 <TimeServed Op="D">10:00 AM</TimeServed>
	 <HowServed Op="D" Word="PERSON">In-Person</HowServed>
	 <WhoWasServed Op="D" InternalPartyID="704607705"/>
	 </ServiceInfo>
 <ServiceInfo Op="D">
   <ServedBy Op="D" Word="GN0170000">County Sheriff's Office</ServedBy>
   <DateServed Op="D">03/24/2014</DateServed>
   <TimeServed Op="D">8:00 PM</TimeServed>
   <HowServed Op="D" Word="SHORTFORM">Short Form</HowServed>
   <WhoWasServed Op="D" InternalPartyID="704607705"/>
    </ServiceInfo>
</ServicesInfo>

Here is my XSLT Selector. How do I change the <xsl:for-each select

Code:

<xsl:template name="ProtectionOrderService">
<xsl:if test="Integration/ControlPoint='SAVE-PROTECTION-ORDER'">
<!-- Check for Added -->
  <xsl:if test="Integration/Case/CaseType/@Word='DMA'">
    <xsl:if test="Integration/ControlPoint/@UserID!='IntegrationAdmin'">
	
<xsl:for-each select="Integration/Case/ProtectionOrders/ProtectionOrder[(@Op='E') and  ((Statuses/Status[(Current='true') and (not(@Op))]/Type/@Word='SIGNJUDCOR') or (Statuses/Status[(Current='true') and (not(@Op))]/Type/@Word='SIGNJUDOFC'))]/KLProtectionOrderAdditional/ServicesInfo/ServiceInfo[(@Op='A') or (@Op='E') or (@Op='D')]">


<NotificationEvent notificationType="ProtectionOrderService">
<xsl:attribute name="elementKey"><xsl:value-of select="../../@InternalProtectionOrderID"/></xsl:attribute>
<xsl:attribute name="elementKey"><xsl:value-of select="../../../@InternalProtectionOrderID"/></xsl:attribute>
<xsl:attribute name="servedByWord"><xsl:value-of select="ServedBy/@Word"/></xsl:attribute>
<xsl:attribute name="servedByText"><xsl:value-of select="ServedBy"/></xsl:attribute>
<xsl:attribute name="dateServed"><xsl:value-of select="DateServed"/></xsl:attribute>
<xsl:attribute name="timeServed"><xsl:value-of select="TimeServed"/></xsl:attribute>
<xsl:attribute name="howServedWord"><xsl:value-of select="HowServed/@Word"/></xsl:attribute>
<xsl:attribute name="howServedText"><xsl:value-of select="HowServed"/></xsl:attribute>
<xsl:attribute name="whoWasServedInternalId"><xsl:value-of select="WhoWasServed/@InternalPartyID"/></xsl:attribute>
<xsl:choose>
<xsl:when test="@Op='A'">Added</xsl:when>
<xsl:when test="@Op='E'">Modified</xsl:when>
<xsl:when test="@Op='D'">Deleted</xsl:when>
</xsl:choose>
</NotificationEvent>
</xsl:for-each>
</xsl:if>
</xsl:if>
</xsl:if>
</xsl:template>

This is the part I need to change but I am not sure how. I think I need to add a WHERE clause and check if there is "A" or "E" or "D". If one is found even if there are several of each ("A", "E", "D"), the out put should only be one message.

Code:

<xsl:for-each select="Integration/Case/ProtectionOrders/ProtectionOrder[(@Op='E') and  ((Statuses/Status[(Current='true') and (not(@Op))]/Type/@Word='SIGNJUDCOR') or (Statuses/Status[(Current='true') and (not(@Op))]/Type/@Word='SIGNJUDOFC'))]/KLProtectionOrderAdditional/ServicesInfo/ServiceInfo[(@Op='A') or (@Op='E') or (@Op='D')]">

samjudson · June 3rd, 2014, 05:36 PM

To get the first ServiceInfo matching the predicate then just use "ServiceInfo[(@Op='A') or (@Op='E') or (@Op='D')][1]"

Also, learn to use attribute value types, much simpler to read and understand I find
, e.g:

<NotificationEvent elementKey="{../../@InternalProtectionOrderID}" ...>

winkimjr2 · June 4th, 2014, 09:37 AM

Thanks Sam for the response and a link to a great article. What I am trying to do with my <xsl:for-each select=...> statement is to generate only one notification. For example if the user delete a service and add another service, there will be only one notification for the added service. I am not sure how to use the where clause in the <xsl:for-each select=...

mhkay · June 4th, 2014, 09:48 AM

Sounds as if you have a "duplicates elimination" problem, also known as a "grouping" problem. It's not clear to me whether you are on XSLT 1.0 or 2.0 - grouping is much easier in 2.0 using the xsl:for-each-group instruction. If you need to do it in 1.0, search for "grouping" or "Muenchian grouping"; it's tricky to master but easy once you work out what's going on.

winkimjr2 · June 4th, 2014, 12:07 PM

Quote:

Originally Posted by mhkay

Sounds as if you have a "duplicates elimination" problem, also known as a "grouping" problem. It's not clear to me whether you are on XSLT 1.0 or 2.0 - grouping is much easier in 2.0 using the xsl:for-each-group instruction. If you need to do it in 1.0, search for "grouping" or "Muenchian grouping"; it's tricky to master but easy once you work out what's going on.

I have Altova Spy 2014 and in this code I am using XSLT 1.0. I can however change it to 2.0. On the interim, I will do as you advice i.e. grouping. Thanks for your help.