Hello Martin, as stated in our documentation at http://docs.basex.org/wiki/Databases#XML_Documents you can further restrict the documents in the collection via the argument. Also, you can get all document names in a database using db:list("database") or even stricter using a path, e.g. db:list("database", "my/path"). Cheers Dirk On 08/28/2015 06:35 PM, Martín Ferrari wrote:
Hello: I wonder if there's a fast way to get the contents or names of the resources that start with a certain path. We have something like this:
string query = @"for $doc in collection() where substring-after(document-uri($doc), '/') = '" + documentName + @"' return $doc/Root";
But our db has millions of resources so this doesn't scale too well. I'd like a way to get the contents (or names) of resources in which the names start with a certain pattern without having to check all names. Is it possible?
The alternative would be to add a field inside the xml resources, index on it, and perform a query.
Thanks, Martín.
-- Dirk Kirsten, BaseX GmbH, http://basexgmbh.de |-- Firmensitz: Blarerstrasse 56, 78462 Konstanz |-- Registergericht Freiburg, HRB: 708285, Geschäftsführer: | Dr. Christian Grün, Dr. Alexander Holupirek, Michael Seiferle `-- Phone: 0049 7531 28 28 676, Fax: 0049 7531 20 05 22