Try this for int sort let $result := <x><z><A>1000</A><A>10</A><A>117</A><A>61</A><A>971</A></z></x>
for $y in $result/z/A order by xs:int($y) return $y or for char sort let $result := <x><z><A>1000</A><A>10</A><A>117</A><A>61</A><A>971</A></z></x> for $y in $result/z/A order by $y return $y Thanks Pradeep Maddireddy On Thu, Jul 1, 2010 at 3:13 PM, Pragya Kapoor <[email protected]>wrote: > *Hi,* > > * * > > *I need to sort the xml on element A.* > > * * > > *let* $result := <*x*><*z*><*A*>1000</*A*><*A*>10</*A*><*A*>117</*A*><*A* > >61</*A*><*A*>971</*A*></*z*></*x*> > > *for* $y *in* $result > > *order* *by* $y/x/z *descending* > > *return* $y > > > > Let me know what I am missing. > > > > Thanks, > > Pragya > > **************** CAUTION - Disclaimer ***************** > This e-mail contains PRIVILEGED AND CONFIDENTIAL INFORMATION intended solely > for the use of the addressee(s). If you are not the intended recipient, please > notify the sender by e-mail and delete the original message. Further, you are > not > to copy, disclose, or distribute this e-mail or its contents to any other > person and > any such actions are unlawful. This e-mail may contain viruses. Infosys has > taken > every reasonable precaution to minimize this risk, but is not liable for any > damage > you may sustain as a result of any virus in this e-mail. You should carry out > your > own virus checks before opening the e-mail or attachment. Infosys reserves the > right to monitor and review the content of all messages sent to or from this > e-mail > address. Messages sent to or from this e-mail address may be stored on the > Infosys e-mail system. > ***INFOSYS******** End of Disclaimer ********INFOSYS*** > > > _______________________________________________ > General mailing list > [email protected] > http://developer.marklogic.com/mailman/listinfo/general > >
_______________________________________________ General mailing list [email protected] http://developer.marklogic.com/mailman/listinfo/general
