XQuery all files under a specific directory?

Question

Can I use XQuery to query all XML files under a specific directory? All the XML files have the same structure.

Also, from what I have seen you can XQuery many files but you need to write the names of them in the query. In my case, I need to query 500 XML files with quite different names each. So Is there a way I can say:

for $x in doc("ALL files under a specific directory")/Foo
return $x/Something

Good question, +1. See my answer for a complete and probably the shortest and most standard solution. — Dimitre Novatchev, Apr 09 '11 at 05:16
I wanted to go into subfolders. I found this option for the collection function in the DataDirect web site: '?select=*.xml;recurse=yes' — charles ross, Jul 17 '17 at 17:36

score 11 · Accepted Answer · edited Sep 30 '15 at 16:56

11

Use the collection() function.

In its Saxon implementation, one can use:

collection('file:///a/b/c/d?select=*.xml')

edited Sep 30 '15 at 16:56

Ares

1,411
1
19
35

answered Apr 09 '11 at 05:16

Dimitre Novatchev

240,661
26
293
431

Zorba collection documentation [here](http://cf.zorba-xquery.com.s3.amazonaws.com/doc/zorba-0.9.4/zorba/html/collections.html) – Pete Oct 11 '13 at 03:24

score 1 · Answer 2 · answered Apr 11 '11 at 12:32

1

For MarkLogic:

for $x in cts:search(fn:doc()/Foo, cts:directory-query("/target/directory/"))
return $x/Something

answered Apr 11 '11 at 12:32

Dave Cassel

8,352
20
38

score 0 · Answer 3 · answered Aug 17 '14 at 18:11

Use the collection() function.

In its Saxon implementation, one can use: collection('file:///a/b/c/d?select=*.xml')

I tried this example under Windows 7 with Saxon HE 9.5.1.5J. The URI then takes a different form, for example: file:/C:/work/GIT/managedSoftwareDoc/experimenting/xQuery?select=*.xml

XQuery all files under a specific directory?

3 Answers3