On 12/02/2024 18:03, Deepak Dinakara wrote:
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.
That one could at least use "to" e.g.
for $i in (1 to 9)!format-integer(., '01')
Not sure that is an improvement, decide for yourself.
