xquery question.. how 2 if possible get tuples that have any attributes or elements of a given value

[Jeff Kish]

Just wondering if it was possible to xquery an xml file to retrieve all elements that had a given text value or all elements where any attribute had a value of interest.

I guess I could figure out a roughshod way to get the elements but I'm not sure about the attributes

Thanks

 

[David Carlisle]

Just wondering if it was possible to xquery an xml file to retrieve all elements that had a given text value //*[.='value']

or all elements where any attribute had a value of interest.
//*[@*='value']

I guess I could figure out a roughshod way to get the elements but I'm not sure about the attributes

Thanks

David

 

[Jeff Kish]

Just wondering if it was possible to xquery an xml file to retrieve all elements that had a given text value //*[.='value']

or all elements where any attribute had a value of interest.
//*[@*='value']

I guess I could figure out a roughshod way to get the elements but I'm not sure about the attributes

Thanks

David

Thank you David.

 

[Jeff Kish]

Just wondering if it was possible to xquery an xml file to retrieve all elements that had a given text value //*[.='value']

or all elements where any attribute had a value of interest.
//*[@*='value']

I guess I could figure out a roughshod way to get the elements but I'm not sure about the attributes

Thanks

David

Is there a way to access the element type?
For example, if the where clause filters out unwanted elements, can I somehow output just the type of element we found things in, rather than the entire element?

I would guess in some other language it would be elementName or some such function.

so
for $b in document("labrep.xml")//presentation
for $a in $b//*[@*="ByContract"]
return
<theAttribute>
{$a/text, $a/@*}
</theAttribute>

I could somehow return "tabletag" if it was found in element <tabletag id="ByContract">...</tabletag>

 

[David Carlisle]

I would guess in some other language it would be elementName or some such function.

name or local-name if you want to ignore namespace prefixes)

This is all Xpath 1, not really anything new in Xquery, although that is true of most of Xquery, really.

David

 

[Jeff Kish]

name or local-name if you want to ignore namespace prefixes)

This is all Xpath 1, not really anything new in Xquery, although that is true of most of Xquery, really.

David

Thanks. I'm still coming up to speed, and it is hard to find things out because there is so much information.. I just need to study example after example, and look over the docs.

thank you once again
Jeff Kish

 

[Jeff Kish]

name or local-name if you want to ignore namespace prefixes)

This is all Xpath 1, not really anything new in Xquery, although that is true of most of Xquery, really.

David

I must be getting old in my thick age.
I don't seem to be getting anything from this, and I expected the name of the element, so maybe you could tell me how I bolluxed up either the syntax, use, or if my expectations are wrong...? I thought name($b) would return the element name, i.e. "<dialog>" in the first case, and some other in the next two.

for $b in document("labrep.xml")//*[@*="ByWorkord"]
return
<temp>{$b/@*, name($b), local-name($b), namespace-uri($b)}</temp>

returns this data

<temp id="ByWorkord"
label="label1"
mboname="MBO1"
width="900"
height="380">dialog dialog </temp>,
<temp id="byworkorder_time_table"
label="label2"
parentmbo="MBO2"
relationship="RELATIONSHIP1"
</temp>,
<temp id="aclaborwo"
label="label3"
parentdatasrc="datasrc1"
relationship="RELATIONSHIP2"
dialog </temp>

Thanks
Jeff Kish

 

[David Carlisle]

I must be getting old in my thick age.
I don't seem to be getting anything from this, and I expected the name of the element, so maybe you could tell me how I bolluxed up either the syntax, use, or if my expectations are wrong...? I thought name($b) would return the element name, i.e. "<dialog>" in the first case, and some other in the next two.

for $b in document("labrep.xml")//*[@*="ByWorkord"]
return
<temp>{$b/@*, name($b), local-name($b), namespace-uri($b)}</temp>

returns this data

<temp id="ByWorkord"
label="label1"
mboname="MBO1"
width="900"
height="380">dialog dialog </temp>,
<temp id="byworkorder_time_table"
label="label2"
parentmbo="MBO2"
relationship="RELATIONSHIP1"
</temp>,
<temp id="aclaborwo"
label="label3"
parentdatasrc="datasrc1"
relationship="RELATIONSHIP2"
dialog </temp>

Thanks
Jeff Kish

well without the input I can only guess, but teh name of an element thatuses a start tag of <dialog> is dialog not <dialog> and local-name is the same if you are not using namespaces. I would guess that the first temp above is the correct output. You generae a temp element node, copy the attribute nodes (which will appear as attributes in the start tag when serialised) then you {$b/@*, then you make a sequence of three strings name($b), local-name($b), namespace-uri($b) when you linearise such a sequence you put spaces between each string so you end up with

dialog dialog

The second <temp< element is not well formed, presumably a cut and paste wrong.

David

 

[Jeff Kish]

well without the input I can only guess, but teh name of an element thatuses a start tag of <dialog> is dialog not <dialog> and local-name is the same if you are not using namespaces. I would guess that the first temp above is the correct output. You generae a temp element node, copy the attribute nodes (which will appear as attributes in the start tag when serialised) then you {$b/@*, then you make a sequence of three strings name($b), local-name($b), namespace-uri($b) when you linearise such a sequence you put spaces between each string so you end up with

dialog dialog

The second <temp< element is not well formed, presumably a cut and paste wrong.

David

Thanks.. I understand a bit more now.
Well, if you have any more time...

I want to see if I can get the element name (i.e. "book" in this case) of the elements with any attribute of value "1992".

I'm getting the entire element <book> in all its glory.. I'd like to just get the "name" of the element that has the attributes, not of its child elements also.

If I use the input below (books.xml)

and I I submit this query

for $b in document("books.xml")//*[@*="1992"]
return
<temp>{$b/@*, $b/.[name]}</temp>

{-- results in this output
<temp year="1992">
<book year="1992">a1992<title>Advanced Programming in the UNIX Environment</title> <author> <last>Stevens</last> <first>W.</first> </author> <publisher>Addison-Wesley</publisher> <price>65.95</price> </book> </temp>
--}

books.xml:

<bib>
<book year="1994">a1994 <title>TCP/IP Illustrated</title> <author> <last>Stevens</last> <first>W.</first> </author> <publisher>Addison-Wesley</publisher> <price>65.95</price> </book> <book year="1992">a1992<title>Advanced Programming in the UNIX Environment</title> <author> <last>Stevens</last> <first>W.</first> </author> <publisher>Addison-Wesley</publisher> <price>65.95</price> </book> <book year="2000">a2000<title>Data on the Web</title> <author> <last>Abiteboul</last> <first>Serge</first> </author> <author> <last>Buneman</last> <first>Peter</first> </author> <author> <last>Suciu</last> <first>Dan</first> </author> <publisher>Morgan Kaufmann Publishers</publisher> <price>65.95</price> </book> <book year="1999">a1999<title>The Economics of Technology and Content for Digital TV</title> <editor> <last>Gerbarg</last> <first>Darcy</first> <affiliation>CITI</affiliation> </editor> <publisher>Kluwer Academic Publishers</publisher> <price>129.95</price> </book> </bib>

Jeff Kish

 

[David Carlisle]

you want the name of $b nwhich is name($b) you have $b/.[name] which is the same as $b[name] which is the same as $b whenever the predicate [name] is true, and since name returns a string not a boolean it's true if the string is non-empty, ie always, as element names are always non empty. so itreturns the whole element node b (which includes all descendents etc)

typing even worse than usual as 1 year old "helping"

David (and Matthew)

 

[Jeff Kish]

you want the name of $b nwhich is name($b) you have $b/.[name] which is the same as $b[name] which is the same as $b whenever the predicate [name] is true, and since name returns a string not a boolean it's true if the string is non-empty, ie always, as element names are always non empty. so itreturns the whole element node b (which includes all descendents etc)

typing even worse than usual as 1 year old "helping"

David (and Matthew)

Keep those 1 year olds in the loop!
Thanks
I'll look it over more

 

[Jeff Kish]

you want the name of $b nwhich is name($b) you have $b/.[name] which is the same as $b[name] which is the same as $b whenever the predicate [name] is true, and since name returns a string not a boolean it's true if the string is non-empty, ie always, as element names are always non empty. so itreturns the whole element node b (which includes all descendents etc)

typing even worse than usual as 1 year old "helping"

David (and Matthew)

I see it is case sensitive, i.e. if I search for any element with any attribute named "ByRecord" it won't find one named "byRecord". Anyway to get by that? I'm searching the docs also... Thanks again. OH.. I have 18, 14, 8 so I know about helping hands!