Hi all,

Just checking how I would create an index for this snippet below.

What I want is an index on cat:catalogue based upon 
cat:catalogue/cat:item/cat:reference/@reference_number.

Would the index below work or will it complain about namespaces?

create index "id"
  on fn:collection("legacy")/cat:catalogue
  by cat:item/cat:reference/@reference_number
  as xs:string

<?xml version='1.0' encoding='UTF-8'?>
<cat:catalogue xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"; 
xsi:type="cat:catalogue_Type" 
xsi:schemaLocation="urn:iso:std:iso:ts:29002:-10:ed-1:tech:xml-schema:catalogue 
http://www.paradine.net/schema/dictionary/1.0/ontoML/ISO29002/catalogue.xsd"; 
xmlns:id="urn:iso:std:iso:ts:29002:-5:ed-1:tech:xml-schema:identifier" 
xmlns:val="urn:iso:std:iso:ts:29002:-10:ed-1:tech:xml-schema:value" 
xmlns:cat="urn:iso:std:iso:ts:29002:-10:ed-1:tech:xml-schema:catalogue" 
xmlns:bas="urn:iso:std:iso:ts:29002:-4:ed-1:tech:xml-schema:basic">
  <cat:item is_global_id="true" 
information_supplier_reference_string="0060-414673376#Z1-AAH017#001" 
local_id="ID7009">
    <cat:reference reference_number="1N4148" organization_code="0060-414673376" 
organization_ref="0060-0#OG-NXP#001">
      <cat:designation>
        <bas:local_string>
          <bas:content>1N4148</bas:content>
          <bas:language_ref>0112-1#LG-EN#001</bas:language_ref>
          <bas:language_code>en</bas:language_code>
          <bas:country_code>US</bas:country_code>
        </bas:local_string>
      </cat:designation>
    </cat:reference>
  </cat:item>
</cat:catalogue>

Kind regards,
Robby
------------------------------------------------------------------------------
Live Security Virtual Conference
Exclusive live event will cover all the ways today's security and 
threat landscape has changed and how IT managers can respond. Discussions 
will include endpoint security, mobile security and the latest in malware 
threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/
_______________________________________________
Sedna-discussion mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/sedna-discussion

Reply via email to