Hello,
I need help with hopefully a simple XQUERY.
I want to extend below XQUERY to run not on all documents in all databases,
but only on those documents which contains "input string X" in its db:path
(i.e. its original file name).
Any help appreciated.
declare variable $n as xs:string external; (: command line query, to be
entered as "n" variable :)
declare option output:item-separator "
"; (: Each element would be in
new line :)
(: Run input query, on every XML document in every Database:)
let $queryData :=
for $db in db:list()
(: Assign dynamic variables to generate query, to be used in eval :)
let $query := "declare variable $db external; " || "db:open($db)" || $n
return xquery:eval($query,map { 'db': $db, 'query': $n })
return distinct-values($queryData)
- Mansi