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.