Hi,
I have XML data with attributes that I've set in attribute indexes with the following consistent format but with different values
form13FFileNumber="028-17473" form13FFileNumber="028-16573"
When I query the data with following without indexes
let $data := db:open('13F')//data[@form13FFileNumber eq $form13FFileNumber]
or with the db:attribute method using indexes
let $data := db:attribute("13F", $form13FFileNumber, "form13FFileNumber")/..
with both queries I get extra data and the same extra data
So if I try to extract form13FFileNumber 028-11185 for example
I get 028-11185 as the first result but also 028-13947 and others...
Similarly for 028-10601 I get data for 028-10601 and 028-17017 and others
does the dash with numbers cause a problem with the indexing?
XQUERY Getting result
xquery version "3.0"; declare namespace db="http://basex.org/modules/db"; declare namespace file="http://expath.org/ns/file"; declare variable $form13FFileNumber as xs:string external;
(:let $data := db:open('13F')//data[@form13FFileNumber eq $form13FFileNumber] :)
let $data := db:attribute("13F", $form13FFileNumber, "form13FFileNumber")/..
let $fields :=
<form13FFile> { for $c in $data return $c
} </form13FFile>
return file:write(concat('../OUTPUT/form13Restatment3rd_' , $form13FFileNumber , '.xml'), $fields)
BD CREATE COMMANDS:
<?xml version="1.0" encoding="UTF-8"?> <commands> <set option='attrinclude'>xml:id,filingDate,type,cik,sequence,form13FFileNumber,periodOfReport</set> <create-db name='13F'/> <info-db/> </commands>
The xml element that has all the indexes <data xml:id="0001534270-16-000006" filingDate="2016-06-08" type="13F-HR" cik="1534270" sequence="000006" form13FFileNumber="028-17473" periodOfReport="03-31-2016">
The basex 744 db is around 8gb and data was added with this xquery
let $docs := collection($path) for $doc in $docs return let $path := concat($doc/data/@periodOfReport,'/',$doc/data/@form13FFileNumber,'/',$doc/data/@xml:id,'.xml') return db:add('13F', $doc, $path)
Regards Alex tech.jahtoe.com bafila.jahtoe.com