Thanks Anuradha its working fine...


Anuradha RG wrote:
> Sheela,
> Try this:
>
> <xsl:for-each select="ANNOTATIONDATA/ANNOTATIONS/ANNOTATION">
> <xsl:sort select="descendant-or-self::*[name() = $SortCol]"
> order="{$SortOrd}"
> data-type="{$SortType}"/>
>
> The "descendant-or-self" will select both the context node and the
> child nodes.
>
> -Anuradha
>
> sheela.37@g... wrote:
> > Hi
> >
> > I have an issue regarding xsl sort.
> > I have implemented the following lines for sort :
> >
> > <xsl:for-each select="ANNOTATIONDATA/ANNOTATIONS/ANNOTATION">
> > <xsl:sort select="*[name() = $SortCol]" order="{$SortOrd}"
> > data-type="{$SortType}"/>
> >
> > This works fine if i loop through
> > ANNOTATIONDATA/ANNOTATIONS/ANNOTATIONS but my sort condition also
> > involves the childnodes of  EXTENDEDITEMS (Supposing the column header
> > includes ENTEREDBYNAME, ANNOTATIONTEXT, EXPDATE and TEXT).
> > Now i need the SortCol to be validated against both main loop of
> > ANNOTATIONS and also the childnodes of EXTENDEDITEMS.
> >
> > My xml looks like this.
> >
> >
> > <ANNOTATIONDATA>
> > 	<EXTENDEDITEMSDEFINITION>
> > 		<EXPDATE ItemName="expdate" SummaryLabel="expdate" ItemType="DT" />
> > 		<TEXT ItemName="Text" SummaryLabel="Te" ItemType="TX" />
> > 	</EXTENDEDITEMSDEFINITION>
> > 	<ANNOTATIONS>
> > 		<ANNOTATIONS>
> > 			<ANNOTATIONID>1305</ANNOTATIONID>
> > 			<ENTEREDDATETIME>11 Dec 2006 17:11</ENTEREDDATETIME>
> > 			<ENTEREDBYNAME>Jill</ENTEREDBYNAME>
> > 			<ANNOTATIONTEXT>expdate: &lt;b&gt;11 Dec 2006&lt;</ANNOTATIONTEXT>
> > 			<EXTENDEDITEMS>
> > 				<EXPDATE>
> > 					<EXTITEMDATAID>8826</EXTITEMDATAID>
> > 					<EXTENDEDITEMID>162</EXTENDEDITEMID>
> > 					<ITEMTYPE>DT</ITEMTYPE>
> > 					<ITEMCODE>expdate</ITEMCODE>
> > 				</EXPDATE>
> > 				<TEXT>
> > 					<EXTITEMDATAID>8827</EXTITEMDATAID>
> > 					<EXTENDEDITEMID>165</EXTENDEDITEMID>
> > 					<ITEMTYPE>TX</ITEMTYPE>
> > 					<ITEMCODE>Text</ITEMCODE>
> > 				</TEXT>
> > 			</EXTENDEDITEMS>
> > 			<EXPIREDIND>0</EXPIREDIND>
> > 		</ANNOTATION>
> > 		<ANNOTATION>
> > 			<ANNOTATIONID>1379</ANNOTATIONID>
> > 			<ENTEREDDATETIME>11 Dec 2006 17:07</ENTEREDDATETIME>
> > 			<ENTEREDBYNAME>Jack</ENTEREDBYNAME>
> > 			<ANNOTATIONTEXT>expdate: &lt;b&gt;11 </ANNOTATIONTEXT>
> > 			<EXTENDEDITEMS>
> > 				<EXPDATE>
> > 					<EXTITEMDATAID>8822</EXTITEMDATAID>
> > 					<EXTENDEDITEMID>162</EXTENDEDITEMID>
> > 					<ITEMTYPE>DT</ITEMTYPE>
> > 					<ITEMCODE>expdate</ITEMCODE>
> > 				</EXPDATE>
> > 			</EXTENDEDITEMS>
> > 			<EXPIREDIND>0</EXPIREDIND>
> > 		</ANNOTATION>
> > 	</ANNOTATIONS>
> > </ANNOTATIONDATA>
> > 
> > Do anyone have any idea regarding this issue????