basex - XQuery Replace Value With Conditional Failing -


i in middle of creating xquery replace-value of node action in xquery.

but seems code not working therefore if-else statement going else.

this code:

declare function local:replacing($contextdata element())  element()* {         copy $pipeline := $contextdata/handler/data/*       modify(     if(not(empty(data($pipeline/payload/sample/transactiontype))))       replace value of node $pipeline/payload/sample/transactiontype 'xxx' else (),    if(not(empty(data($pipeline/payload/sample/revision))))      replace value of node $pipeline/payload/sample/revision 'xxx' else ()        )  return $pipeline  };

i try against sample xml result not xxx when field revision having value. (this goes else statement)

let $result := <root> <handler>   <data>     <root>        <payload>             <sample>             <transactiontype></transactiontype>             <revision>123</revision>             <board>1</board>             <mission>1</mission>             <method>manual</method>             <listofboard>               <board>                 <type>small</type>                 <amount>5054</amount>                 <token>300</token>               </board>             </listofboard>             <pricing>300</pricing>             <playing>wed</playing>           </sample>        </payload>      </root>    </data> </handler> </root>

current result:

<root>   <payload>     <sample>       <transactiontype/>       <revision>123</revision>       <board>1</board>       <mission>1</mission>       <method>manual</method>       <listofboard>         <board>           <type>small</type>           <amount>5054</amount>           <token>300</token>         </board>       </listofboard>       <pricing>300</pricing>       <playing>wed</playing>     </sample>   </payload> </root>

expected result

<root>       <payload>         <sample>           <transactiontype/>           <revision>xxx</revision>           <board>1</board>           <mission>1</mission>           <method>manual</method>           <listofboard>             <board>               <type>small</type>               <amount>5054</amount>               <token>300</token>             </board>           </listofboard>           <pricing>300</pricing>           <playing>wed</playing>         </sample>       </payload>     </root>

any ideas this?

update

as recommended har below, change code into:

 if(not(empty(data($pipeline/payload/sample/transactiontype))))               replace value of node $pipeline/payload/sample/transactiontype 'xxx'          else (             if(not(empty(data($pipeline/payload/sample/revision))))             replace value of node $pipeline/payload/sample/revision 'xxx' else ()          )

but seems result same. still goes else () statement. ideas?

thank before.

the problem was, empty() checks empty sequence, sequence containing 1 empty string considered true empty(). can pass data() result if since empty has effective boolean value of false :

if(data($pipeline/payload/sample/transactiontype))      replace value of node $pipeline/payload/sample/transactiontype 'xxx' else (), if(data($pipeline/payload/sample/revision))     replace value of node $pipeline/payload/sample/revision 'xxx' else ()

-

Popular posts from this blog

Apache NiFi ExecuteScript: Groovy script to replace Json values via a mapping file -

i working apache nifi 0.5.1 on groovy script replace incoming json values ones contained in mapping file. mapping file looks (it simple .txt): header1;header2;header3 a;some text;a2 i have started following: import groovy.json.jsonbuilder import groovy.json.jsonslurper import java.nio.charset.standardcharsets def flowfile = session.get(); if (flowfile == null) { return; } flowfile = session.write(flowfile, { inputstream, outputstream -> def content = """ { "field1": "a" "field2": "a", "field3": "a" }""" def slurped = new jsonslurper().parsetext(content) def builder = new jsonbuilder(slurped) builder.content.field1 = "a" builder.content.field2 = "some text" builder.content.field3 = "a2" outputstream.write(builder.toprettystring().ge...
Read more

node.js - How do I prevent MongoDB replica set from querying the primary? -

read-operations-only: is there way have mongodb replica set, make mongodb instance on box connected to, mongodb gets queried? i have 3 ec2 instances behind aws load balancer. on each ec2 instance runs mongodb, part of replica set. i have express endpoints on nodejs , connect replica set follows mongodb.mongoclient.connect('mongodb://1.1.1.1,2.2.2.2,3.3.3.3.', function (err, db) { if (err) { complete('{}'); } else { i distribute load of queries evenly across 3 instances of mongodb replica set instead of default having queries routed ec2 instance primary mongodb defined, because destroys point of load balancer (which balance load of queries across 3 instances evenly). my understanding when connecting mongodb replica set, primary instance selected unless primary instance down, , therefore purpose of every secondary instance serve backup. in example people call hot,cold,cold. because there 2...
Read more