[basex-talk] and operator in Multiple Predicates

23 Mar 2017

      Namaste ,

and operator in predicates seems tobe not working.

my xquery is as below and xml is attached herewith.

declare namespace UDF="TallyUDF";
let $fromdate:=20170228
let $todate:=20170228
let $pledger_code:=57
let  $pledger_status:="P"
for $allitems in db:open('10096',"Vouchers")/ENVELOPE/Voucher[./Date/text()
...
= $fromdate and ./Date/text() <= $todate and
./AllLedgerEntries.LIST/UDF:AsPerListAllocations.LIST/UDF:ColPartyCode.LIST/UDF:ColPartyCode/text()=
$pledger_code and
./AllLedgerEntries.LIST/UDF:AsPerListAllocations.LIST/UDF:MaheshCIFlag.LIST/UDF:MaheshCIFlag/text()=
$pledger_status]
return
 $allitems/MasterId

Expected 2 records/nodes instead 4.
Tushar Deshmukh,