obtain element name, or attribute and value of the document name itself, and some elemnts and attrib

[Jeff Kish]

Hi.

I've been experimenting more with xquery trying to get back into it.

I am not seeing how to, given some query that returns a set of
elements, how to do the following:

given an operation over a collection of documents,
find all the elements <table> that have an attribute called relation,
and return the files names, and some of the attributes of
the returned element and some of their particular ancestor's
attributes.... something like this;

xxx.xml

segment speed="1"
table1 relation="upper"
table3 relation="upper"

xxy.xml
segment speed="2"
table2 relation="lower"


given this xml file set:


document xxx.xml

<area>
<segment id="segment1" speed="1">
<table id="table1" relation="upper" />
<table id="table2" orientation="side" />
<table id="table3" relation="upper" />
</segment>
</area>




document xxy.xml

<area>
<segment id="segment1" speed="2">
<table id="table1" orientation="bottom" />
<table id="table2" relation="lower" />
<table id="table3" orientation"top" />
</segment>
</area>

 

[Martin Honnen]

xxx.xml

segment speed="1"
table1 relation="upper"
table3 relation="upper"

xxy.xml
segment speed="2"
table2 relation="lower"


given this xml file set:


document xxx.xml

<area>
<segment id="segment1" speed="1">
<table id="table1" relation="upper" />
<table id="table2" orientation="side" />
<table id="table3" relation="upper" />
</segment>
</area>




document xxy.xml

<area>
<segment id="segment1" speed="2">
<table id="table1" orientation="bottom" />
<table id="table2" relation="lower" />
<table id="table3" orientation"top" />
</segment>
</area>

Here is an example XQuery,

string-join(
for $d in
collection('.?select=test20081030*.xml')[descendant::table[@relation]]
return
(tokenize(base-uri($d), '/')[last()], '',
concat('segment speed="',
$d//table[@relation]/ancestor::segment/@speed, '"'),
for $t in $d//table[@relation]
return concat($t/@id, ' relation="', $t/@relation, '"'), '')
, '
')

that returns the described result when run with Saxon 9 in a working
directory that contains the input files as test20081030nn.xml

 

[kishjeff]

xxx.xml

segment speed="1"
table1 relation="upper"
table3 relation="upper"

xxy.xml
segment speed="2"
table2 relation="lower"

given this xml file set:

document xxx.xml

<area>
<segment id="segment1" speed="1">
<table id="table1"  relation="upper"    />
<table id="table2"  orientation="side" />
<table id="table3"  relation="upper"   />
</segment>
</area>

document xxy.xml

<area>
<segment id="segment1" speed="2">
<table id="table1"  orientation="bottom"    />
<table id="table2"  relation="lower" />
<table id="table3"  orientation"top"   />
</segment>
</area>

Here is an example XQuery,

string-join(
for $d in
collection('.?select=test20081030*.xml')[descendant::table[@relation]]
return
   (tokenize(base-uri($d), '/')[last()], '',
   concat('segment speed="',
$d//table[@relation]/ancestor::segment/@speed, '"'),
   for $t in $d//table[@relation]
   return concat($t/@id, ' relation="', $t/@relation, '"'), '')
, '
')

that returns the described result when run with Saxon 9 in a working
directory that contains the input files as test20081030nn.xml

Thanks. I'm using IPSI XQuery Interpreter v.1.3.4 which may be a bit
long in the tooth (I don't think it is complete as I could not get
starts-with to work) - let me give this a fly.

thanks much Martin.

Jeff

 

[kishjeff]

Here is an example XQuery,

string-join(
for $d in
collection('.?select=test20081030*.xml')[descendant::table[@relation]]
return
   (tokenize(base-uri($d), '/')[last()], '',
   concat('segment speed="',
$d//table[@relation]/ancestor::segment/@speed, '"'),
   for $t in $d//table[@relation]
   return concat($t/@id, ' relation="', $t/@relation, '"'), '')
, '
')

that returns the described result when run with Saxon 9 in a working
directory that contains the input files as test20081030nn.xml
--

        Martin Honnen
       http://JavaScript.FAQTs.com/

Thanks. I'm using IPSI XQuery Interpreter v.1.3.4 which may be a bit
long in the tooth (I don't think it is complete as I could not get
starts-with to work) - let me give this a fly.

thanks much Martin.

Jeff

This was soooo helpful, thanks.
I have a related question..

I tried using this for fun (notice the extra base-uri($d) in the
beginning of the last
return statement):

string-join(
for $d in
collection('.?select=test20081030*.xml')[descendant::table[@relation]]
return
base-uri($d),(tokenize(base-uri($d), '/')[last()], '',
concat('segment speed="',
$d//table[@relation]/ancestor::segment/@speed, '"'),
for $t in $d//table[@relation]
return concat($t/@id, ' relation="', $t/@relation, '"'), '')
, '
')

I noticed that when I use this instead, I get the error:

XPST0008: XQuery static error in #...ri($d),(tokenize(base-
uri($d),#:
Variable $d has not been declared
Static error(s) in query

 

[Martin Honnen]

I tried using this for fun (notice the extra base-uri($d) in the
beginning of the last
return statement):

string-join(
for $d in
collection('.?select=test20081030*.xml')[descendant::table[@relation]]
return

Add parentheses e.g
(base-uri($d),(tokenize(base-uri($d), '/')[last()], '',

base-uri($d),(tokenize(base-uri($d), '/')[last()], '',
concat('segment speed="',
$d//table[@relation]/ancestor::segment/@speed, '"'),
for $t in $d//table[@relation]
return concat($t/@id, ' relation="', $t/@relation, '"'), '') )
, '
')