Yes, it did help. Thanks a ton : )
On Tue, Feb 13, 2024, 00:08 Christian Grün <[email protected]>
wrote:
> 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 <[email protected]> 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
>>
>>
