Maybe it's a newbie issue, but I would like your comments.

I'm writing a RESTXQ method to search among a couple of databases. ( >100 databases )

Some databases are split into a couple of parts due to the number of nodes. For example US: it's separated into US00, US01 and US02.

So, my problem is:

if I replace "for $usPart in ('US00')" by "for $usPart in ('US00','US01',''US02)" in QUERY [A], I get this error:

Using "for $usPart in ('US00')" it works without any problem. With one element there is no problem, with two or more it fails.

Any ideas about what I'm doing wrong?

Here is the

-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

declare namespace gb="http://www.ipo.gov.uk/schemas/tm";

let $text:="christian"
let $registries:=('GB','US')

let $results :=
  for $registry in $registries
   return
   switch ($registry)
 
           case "US"
           return
           (# db:enforceindex #) {
                  for $usPart in ('US00')
                  for $tmUS in db:open($usPart)/trademark-applications-daily/application-information/file-segments/action-keys/case-file
                  where $tmUS/case-file-header/mark-identification/text() contains text {$text} using stemming
                  return <trademark><ipo>US</ipo><text>{$tmUS/case-file-header/mark-identification/text()}</text></trademark>
                }

           case "GB"
           return
               (# db:enforceindex #) {
                   for $tmGB in db:open('GB')/gb:MarkLicenceeExportList/gb:TradeMark
                  where $tmGB/gb:WordMarkSpecification/gb:MarkVerbalElementText/text() contains text {$text}
                    return <trademark><ipo>GB</ipo><text>{$tmGB/gb:WordMarkSpecification/gb:MarkVerbalElementText/text()}</text></trademark>              
                }      

            default return ""

    return
    <result>
        <total>{count($results)}</total>
        <trademarks>
        {
            for $result in $results
            return $result
        }
        </trademarks>        
    </result>

Regards,

Sebastian