(no subject)

Dear Team, Following is my query -

for $x in db:fulltext('Doc', 'Molecular Biology')/ancestor::*:Doc
return $x/ArticleNo

This query will return all the ArticleNo having the words "Molecular Biology" The output of this query is like a PHRASE... where the phrase is "Molecular Biology" Now I want to list all the ArticleNo which might have word "Molecular" OR/AND "Biology" How can I get this using the above query... ??

Hi John,

"intersect", "union" and "except" can be used to perform set-based logical operations:

  let $a := db:fulltext('Doc', 'Molecular')
  let $b := db:fulltext('Doc', 'Biology')
  let $c := $a union $b
  return $c/ancestor::*:Doc/ArticleNo