[basex-talk] Xquery over all collections

Hello List

I am wanting to query all collections in BaseX 7.5 without hard coding the names of each collection in my xquery.

I can list the collections with db:list() but am struggling to get something like

let $r := (collection('A'), collection('B'), collection('C'))/xml/indicator[code='myCode']

I can use db:list() to get all documents in all collections in this way:

let $q := for $a in (db:list()) let $e :=string-join( $a, ',') return $e let $z := for $x in $q return db:open($x) for $r in $z return $r

Can anyone please suggest a way of using db:list and other functions in xquery to perform a query on all collections.

Cheers

Peter