Hello,

I would like to assign a sequence to a variable and then share this variable between two expressions. Particularly I want to create a list of documents to delete from the db and then return the number of deleted documents.

Code sketch of what I am trying:

let $nodes := [...]

let $base-uris := for $node in $nodes return base-uri($node)

let $distinct-base-uris := distinct-values($base-uris)

for $base-uri in $distinct-base-uris return db:delete("db", $base-uri),

return count($distinct-base-uris)

---

The problem with this approach is that $distinct-base-uris is local to the first expressions and not in scope for the count call.

I tried to just duplicate all code, but then I get an error message that "no updating expression [is] allowed".

Is there any way to achieve what I want and put my value in a scope accessible by both expressions?

Regards,

Johannes