Hi Deepak,

For deletions, you can write:

let $db := 'db'

for $path in db:list($db, '2023')[matches(., '/\d\d')]

return db:delete($db, $path)

When accessing documents, it’s faster to iterate over the resources:

for $doc in db:get('db', '2023')

where matches(db:path($doc), '/\d\d')

return ...

Hope this helps,

Christian 

Deepak Dinakara <deepukalmane@gmail.com> schrieb am Mo., 12. Feb. 2024, 18:04:

Hi,

I wanted to know if it's possible to give a regex while deleting a resource.

I have documents stored in a hierarchy of collections like {year}{month}/doc.xml.

Eg: 202301/abc.xml, 202302/def.xml.

If I want to delete a resource "abc.xml", Is it possible to issue commands like "db:delete("db-name", '/*/abc.xml')" ? Right now, I can do a XQuery with db:list and endsWith and get the complete path of "abc.xml". But regex would have been very handy.

Similarly I also want to execute queries against a list of collections using regex.

Something like "for $document in collection('db-name/20230*')" (First 9 months of 2023)

Right now, I am doing something like 

"for $i in ('01', '02', '03', '04', ... '09')
for $document in collection('test-collection/2023' || $i)"

But if there are better ways, kindly let me know.

Thank you,

Deepak