slightly convoluted query question

[kishjeff]

I'm still looking at this.. is this even possible?
I'd like to search a set of xml files
I want to skip all xml files that have a <client> element that
contains more than one <majortab> element,
but otherwise search for some elements with a @select attribute.

So I'm not sure how to skip the docs (or at least prevent them from
being included in the results) that have say:

<client>
<majortab ... /><majortab ... />
</client>

thanks for the hints.. still reading honestly!

Jeff

 

[Martin Honnen]

I'm still looking at this.. is this even possible?
I'd like to search a set of xml files
I want to skip all xml files that have a <client> element that
contains more than one <majortab> element,
but otherwise search for some elements with a @select attribute.

So I'm not sure how to skip the docs (or at least prevent them from
being included in the results) that have say:

<client>
<majortab ... /><majortab ... />
</client>

Well if you use XSLT or XQuery then you can certainly check whether
count(/client/majortab) > 1
With XSLT 2.0 or XQuery 1.0 you can load multiple XML source documents
using the collection function, see
http://www.saxonica.com/documentation/sourcedocs/collections.html for
instance how that works with Saxon 9.

 

[Jeff Kish]

Well if you use XSLT or XQuery then you can certainly check whether
count(/client/majortab) > 1
With XSLT 2.0 or XQuery 1.0 you can load multiple XML source documents
using the collection function, see
http://www.saxonica.com/documentation/sourcedocs/collections.html for
instance how that works with Saxon 9.

Yes, I have used the collection to load multiples, but I am not sure
how to exclude them from the processing based on whether or not they
have a certain element combination.

It is xquery, but a slightly older version... it is actually
ipsi-xq-1.3.4

I really like it.
Unfortunately it seems to be having a problem with starts-with
functions so I might have to cast about for another implementation if
I need to use that.

So I'm not sure how to structure the query so that the client/majortab
count > 1 go ahead v.s. skip if < =1

thanks
Jeff

 

[Martin Honnen]

So I'm not sure how to structure the query so that the client/majortab
count > 1 go ahead v.s. skip if < =1

Well you could use the condition in a predicate when you select nodes e.g.

collection('file:///C:/someDir?select=*.xml')/foo/client[count(majortab)

> 1]

or you could use a where condition

for $client in collection('file:///C:/someDir?select=*.xml')/foo/client
where count($client/majortab) > 1
return $client

 

[kishjeff]

So I'm not sure how to structure the query so that the client/majortab
count > 1 go ahead v.s. skip if < =1

Well you could use the condition in a predicate when you select nodes e.g..

collection('file:///C:/someDir?select=*.xml')/foo/client[count(majortab)
 > 1]

or you could use a where condition

   for $client in collection('file:///C:/someDir?select=*.xml')/foo/client
   where count($client/majortab) > 1
   return $client

I'll try it, thanks much.