xslt - how to sort elements and group them based on unique element or ID, which has namespace -


i have asked same question not namespace

i have xml like..this

 <?xml version = '1.0' encoding = 'utf-8'?> <finaldbgetuserid>   <finaldbgetuseridoutputcollection xmlns:ns0="http://xmlns.oracle.com/pcbpel/adapter/db/finaldbgetuserid"                                     xmlns="http://xmlns.oracle.com/pcbpel/adapter/db/finaldbgetuserid">     <ns0:userubscribers>       <ns0:user_id>237</ns0:user_id>       <ns0:businessentity>         <ns0:nevada_business_id>nv0511201114</ns0:nevada_business_id>         <ns0:business_entity_id>207</ns0:business_entity_id>       </ns0:businessentity>     </ns0:userubscribers>     <ns0:userubscribers>       <ns0:user_id>237</ns0:user_id>       <ns0:businessentity>         <ns0:nevada_business_id>nv0511201119</ns0:nevada_business_id>         <ns0:business_entity_id>212</ns0:business_entity_id>       </ns0:businessentity>     </ns0:userubscribers>     <ns0:userubscribers>       <ns0:user_id>237</ns0:user_id>       <ns0:businessentity>         <ns0:nevada_business_id>nv0511201129</ns0:nevada_business_id>         <ns0:business_entity_id>230</ns0:business_entity_id>       </ns0:businessentity>     </ns0:userubscribers>   </finaldbgetuseridoutputcollection> </finaldbgetuserid>

output should like

 <finaldbgetuserid>   <finaldbgetuseridoutputcollection xmlns:ns0="http://xmlns.oracle.com/pcbpel/adapter/db/finaldbgetuserid"                                     xmlns="http://xmlns.oracle.com/pcbpel/adapter/db/finaldbgetuserid">     <ns0:userubscribers>       <ns0:user_id>237</ns0:user_id>       <ns0:businessentity>         <ns0:nevada_business_id>nv0511201114</ns0:nevada_business_id>         <ns0:business_entity_id>207</ns0:business_entity_id>       </ns0:businessentity>       <ns0:businessentity>         <ns0:nevada_business_id>nv0511201119</ns0:nevada_business_id>         <ns0:business_entity_id>212</ns0:business_entity_id>       </ns0:businessentity>       <ns0:businessentity>         <ns0:nevada_business_id>nv0511201129</ns0:nevada_business_id>         <ns0:business_entity_id>230</ns0:business_entity_id>       </ns0:businessentity>     </ns0:userubscribers>   </finaldbgetuseridoutputcollection> </finaldbgetuserid>

following below xslt, trying , not getting desired result

 <xsl:stylesheet version="1.0"  xmlns:xsl="http://www.w3.org/1999/xsl/transform">  <xsl:output omit-xml-declaration="yes" indent="yes"/>  <xsl:strip-space elements="*"/>   <xsl:key name="kuserid" match="userubscribers"  use="user_id"/>   <xsl:template match="node()|@*">      <xsl:copy>        <xsl:apply-templates select="node()|@*">          <xsl:sort select="user_id" data-type="number"/>        </xsl:apply-templates>      </xsl:copy>  </xsl:template>    <xsl:template match=  "userubscribers|user_id  |businessentity"/>   <xsl:template match=   "userubscribers     [generate-id()     =      generate-id(key('kuserid', user_id)[1])      ]">   <userubscribers>    <xsl:copy-of select="user_id"/>    <xsl:apply-templates mode="copy" select="key('kuserid',user_id)" />   </userubscribers>  </xsl:template>   <xsl:template match="userubscribers" mode="copy">   <businessentity>    <xsl:apply-templates/>   </businessentity>  </xsl:template> </xsl:stylesheet>

i getting output same input , there no change. may doing mistake, not getting mistake .... trying find out

define xmlns:ns0="http://xmlns.oracle.com/pcbpel/adapter/db/finaldbgetuserid" on xsl:stylesheet element, use prefix ns0 anywhere in stylesheet match or select elements namespace e.g. <xsl:key name="kuserid" match="ns0:userubscribers" use="ns0:user_id"/> , <xsl:sort select="ns0:user_id" data-type="number"/>.


Comments

Post a Comment

Popular posts from this blog

c# - SharpSVN - How to get the previous revision? -

i trying find efficient way previous revision of file text comparison using sharpsvn. using (svnclient c = new svnclient()) { c.authentication.defaultcredentials = new networkcredential( configurationmanager.appsettings.get("svnserviceusername") , configurationmanager.appsettings.get("svnservicepassword") , configurationmanager.appsettings.get("svnservicedomain") ); c.authentication.sslservertrusthandlers += new eventhandler<svnsslservertrusteventargs>(authentication_sslservertrusthandlers); collection<svnfileversioneventargs> fileversioncollection = new collection<svnfileversioneventargs>(); svnrevisionrange range = new svnrevisionrange(0, this.hooks.revision); svnfileversionsargs args = new svnfileversionsargs(); args.retrieveproperties = true; args.range = range; foreach (svnchangeitem item in log.changedpaths) { string path = this.repositorypath + it...
Read more

c++ - Is it possible to compile a VST on linux? -

for class project i'm attempting write vst plugin backed cuda. current cuda workflow on linux box, i'd prefer compile , link there. according wikipedia , should possible (i couldn't find steinberg documentation relevant linux) can't find makefile or instructions on how build if aren't using xcode or visual studio. i'm vst 3 sdk doesn't support linux. when try compile plugin under linux, error: ./base/source/fatomic.cpp:39:30: fatal error: libkern/osatomic.h: no such file or directory this issue caused following code in "vst3 sdk/base/source/fatomic.cpp" #if mac #include <libkern/osatomic.h> #if mac_os_x_version_min_required > mac_os_x_version_10_4 #define native_atomic_type (volatile int32_t*) #else #define native_atomic_type (int32_t*) #endif #elif windows #include <windows.h> #endif but hope compiling under linux work vst sdk 2.4. reading. jvstwrapper seems run on lin...
Read more

url - Querystring manipulation of email Address in PHP -

i using third party application (email2http) send me emailid, body , message. unable retrieve email id due name appended on , enclosed < , >. here querystring getting. test.php?from=ajay+reddy &subject=cx&body=somebody when print variable in php returns name , not email id. $from = $_get['from']; echo $from; //output ajay reddy please suggest me how can emailid also. i dont want use post method due testing , debugging. it's working fine. forgot use htmlentities() in debugging.
Read more