Hi Rodolfo,
Most likely you forgot to declare default namespace. Something like this
should help:
declare default element namespace "
http://schemas.fortaleza.ce.gov.br/acao/controledigitacao.xsd";;
CREATE INDEX "control" ON
collection("leitura-1")/registroDigitacao/documento BY
controle AS xs:integer
Ivan Shcheklein,
Sedna Team
Hello there,
>
> I have a collection named "leitura-1"
>
> documents has the following structure:
>
> <?xml version="1.0" standalone="yes"?>
> <registroDigitacao xmlns="
> http://schemas.fortaleza.ce.gov.br/acao/controledigitacao.xsd";>
> <digitacao>
>
> <digitador>uid=isabel.sinena,dc=GP,dc=rh,dc=diretorio,dc=fortaleza,dc=ce,dc=gov,dc=br</digitador>
> <dataDigitacao>2011-02-03T18:17:19</dataDigitacao>
> <localDigitacao>200.223.251.139</localDigitacao>
> </digitacao>
> <leitura>
> <id>1</id>
> <instrumento>
> <nome>Caderno A</nome>
> <xmlSchema>viladomar-cadernoa.xsd</xmlSchema>
> <projeto>
> <id>1</id>
> <nome>Vila do Mar</nome>
> </projeto>
> </instrumento>
> </leitura>
> <documento>
>
> <id>digitacao_1_Caderno_A_1_uid_isabel_sinena_dc_GP_dc_rh_dc_diretorio_dc_fortaleza_dc_ce_dc_gov_dc_br_1296757039</id>
> <controle>4298</controle>
> <estadoControle>Aberto</estadoControle>
> <cd:estado xmlns:cd="
> http://schemas.fortaleza.ce.gov.br/acao/controledigitacao.xsd
> ">Aprovado</cd:estado>
> <conteudo>
> <formCadernoA xmlns="
> http://schemas.fortaleza.ce.gov.br/habitafor/viladomar-cadernoa.xsd";>
>
> I'm trying the following:
>
> CREATE INDEX "control"
> ON collection("leitura-1")/registroDigitacao/documento BY controle
> AS xs:integer
>
> the following brings me nothing:
> for $x in index-scan("control", 4298, "EQ") return $x
>
> any clue on what I'm doing wrong?
>
> thanks!
>
>
> ------------------------------------------------------------------------------
> WhatsUp Gold - Download Free Network Management Software
> The most intuitive, comprehensive, and cost-effective network
> management toolset available today. Delivers lowest initial
> acquisition cost and overall TCO of any competing solution.
> http://p.sf.net/sfu/whatsupgold-sd
> _______________________________________________
> Sedna-discussion mailing list
> Sedna-discussion@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/sedna-discussion
>
>
------------------------------------------------------------------------------
WhatsUp Gold - Download Free Network Management Software
The most intuitive, comprehensive, and cost-effective network
management toolset available today. Delivers lowest initial
acquisition cost and overall TCO of any competing solution.
http://p.sf.net/sfu/whatsupgold-sd
_______________________________________________
Sedna-discussion mailing list
Sedna-discussion@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/sedna-discussion
