Printing adjacent values when the condition is met in XSLT

santhakumar · July 7th, 2013, 06:57 PM

<accountList>
<account>
<Title>Mr</Title>
<firstName>Richard</firstName>
<lastName>John</lastName>
<city>london</city>
<accNo>16</accNo>
</account>
<account>
<Title>Mr</Title>
<firstName>xxx</firstName>
<lastName>John</lastName>
<city>London</city>
<accNo>17</accNo>
</account>

<account>
<Title>Mr</Title>
<firstName>Hewit</firstName>
<lastName>John</lastName>
<city>london</city>
<accNo>20</accNo>
</account>
<account>
<Title>Mr</Title>
<firstName>xxx</firstName>
<lastName>John</lastName>
<city>london</city>
<accNo>21</accNo>
</account>
</accountList>

Output required:

If more than one person have the same last name(like Richard John & Hewit John) and their first names are XXX,

16 Richard John 17 (xxx for the Richard John, is more important to bring it here ') The 16 and 17 are accNo.
20 Hewit John 21 (xxx for the Hewit John,21(accNo)

Its working fine for the one element, ie <account> . If i have more one lastname my logic is not working. My problem is if i have more than one lastname,its simply not printing the result. Its unable to find the correct accNo for the corresponding lastName and firstName as well. Please help me out.

My Code:

<xsl:variable name="exstacc">
<xsl:for-each select="//accountList/account">
<xsl:if test="firstName='xxx'">
<xsl:value-of select="accNo"/>
</xsl:if>
</xsl:for-each>
</xsl:variable>
<xsl:variable name="accLastname">
<xsl:for-each select="//accountList/account">
<xsl:if test="firstName='xxx'">
<xsl:value-of select="lastName"/>
</xsl:if>
</xsl:for-each>
</xsl:variable>

<xsl:choose>
<xsl:when test="firstName='xxx' '">
<xsl:if test="lastName=$accLastname">
<xsl:text>EXTRA ACCS(S)</xsl:text>
<xsl:text> </xsl:text>
<xsl:value-of select="$exstacc"/>
</xsl:if>
</xsl:when>
</xsl:choose>

mhkay · July 7th, 2013, 07:05 PM

You need to put a little more effort into describing the specification of the problem. Please try to write in whole sentences - there's no 140-character limit here. At present your description is far too cryptic, so it's hard to work out what the problem is.

santhakumar · July 8th, 2013, 07:19 AM

I have updated my question .Please have a look Mhkay.

mhkay · July 8th, 2013, 09:06 AM

If I understand your specification correctly, you want to output one entry for each customer, where a customer is defined as a group of adjacent account elements such that the surname within the group matches, and the first name in every account except the first is "xxx". (There's a lot of guess work in extracting that specification from your examples so I might well have got it wrong.)

So that's something like

Code:

<xsl:template match="accountList">
  <xsl:for-each-group select="account" 
    group-starting-with="*[firstName != 'xxx' or lastName != preceding-sibling::*[1]/lastName]">
    <xsl:value-of select="current-group()[1]/(accNo, lastName, firstName),
           current-group()[position() gt 1]/accNo, '&#xa;'"/>
  </xsl:for-each-group>
</xsl:template>

santhakumar · July 9th, 2013, 06:23 AM

Hi Mhkay,

Thanks for the reply. Your logic is correct. Its working fine. As you told that
I didnt clearly explained as well.
Clearly I have explained the problem as below,Please help me out

Code:

<Primary>
<Secondary>
            <AccountDetails>
                <Title>Mr</Title>
                <FirstName>JOHN</FirstName>
                <LastName>DONALD</LastName>
                <Gender>Male</Gender>
            </AccountDetails>
            <AccNoDetails>
                <accNo>025</accNo>
                <Reason>nothing</Reason>
             <PassengerStatus>
                <Active>true</Active>
            </PassengerStatus>
            <BookingDetails>
                <Reference>025</Reference>
                <activeCustomer>F</activeCustomer>
            </BookingDetails>
  <Secondary>
<Secondary>
             <AccountDetails>
                <Title>Mr</Title>
                <FirstName>XXX</FirstName>
                <LastName>DONALD</LastName>
                <Gender>Male</Gender>
            </AccountDetails>
            <AccNoDetails>
                <accNo>026</accNo>
                <Reason>nothing</Reason>
             <PassengerStatus>
                <Active>true</Active>
            </PassengerStatus>
            <BookingDetails>
                <Reference>026</Reference>
                <activeCustomer>F</activeCustomer>
            </BookingDetails>
  <Secondary>
<Secondary>
            <AccountDetails>
                <Title>Mr</Title>
                <FirstName>RICHARD</FirstName>
                <LastName>PARKER</LastName>
                <Gender>Male</Gender>
            </AccountDetails>
            <AccNoDetails>
                <accNo>025</accNo>
                <Reason>nothing</Reason>
             <PassengerStatus>
                <Active>true</Active>
            </PassengerStatus>
            <BookingDetails>
                <Reference>028</Reference>
                <activeCustomer>F</activeCustomer>
            </BookingDetails>
  <Secondary>
<Secondary>
             <AccountDetails>
                <Title>Mr</Title>
                <FirstName>ALAN</FirstName>
                <LastName>DONALD</LastName>
                <Gender>Male</Gender>
            </AccountDetails>
            <AccNoDetails>
                <accNo>030</accNo>
                <Reason>nothing</Reason>
             <PassengerStatus>
                <Active>true</Active>
            </PassengerStatus>
            <BookingDetails>
                <Reference>025</Reference>
                <activeCustomer>F</activeCustomer>
            </BookingDetails>
  <Secondary>
<Secondary>
             <AccountDetails>
                <Title>Mr</Title>
                <FirstName>xxx</FirstName>
                <LastName>DONALD</LastName>
                <Gender>Male</Gender>
            </AccountDetails>
            <AccNoDetails>
                <accNo>025</accNo>
                <Reason>nothing</Reason>
             <PassengerStatus>
                <Active>true</Active>
            </PassengerStatus>
            <BookingDetails>
                <Reference>031</Reference>
                <activeCustomer>F</activeCustomer>
            </BookingDetails>
  <Secondary>   

Required output.

AccNo FirstName LastName  Gender  ExtraAccNo

025    JOHN        DONALD    Male     ExtraAccNo:026    
028    RICHARD   PARKER     Male     
030    ALAN        DONALD    Male    ExtraAccNo:031

Note:
1.('ExtraAccNo' should be hardcoded)
2.(I wont print Hardcode 'ExtraAccNo' in the second row, because his first name doesnt have 'xxx' in the upcoming elements

'xxx' <secondary> element should be removed from the row,Just I used it for retrieving AccNo

Here based on conditions only i am displaying the Hardcoded 'ExtraAccNo:' and those corresponding AccNo.

The problem is I already done for-each for AccNo FirstName LastName Gender display.Because already I have done more conditions(code part). Is it possible bring the exact 'ExtraAccNo:AccNo' for the particular row?

conditions are explained in my last post.

santhakumar · July 11th, 2013, 04:23 AM

Thanks Mhkay.I solved my issue by solution you provided