tags:

views:

9

answers:

0

I have three scopes:

  • scope A with rule include http: //mywebapp/lists/myList
  • scope B with rule include FileExtenion aspx
  • scope C with rule include http: //mywebapp/mysitecollection2/

some managed properties mapped to columns from myList, ows_contenttype, ows_created (Property1,2,3)

select title, url, description, Property1, Property2, Property3 from Scope() where scope = 'A' this returns 15 resullts

select title, url, description, Property1, Property2, Property3 from Scope() where scope = 'B' this returns 50 results

select title, url, description, Property1, Property2, Property3 from Scope() where scope = 'C' this returns 10 results

so why this query select title, url, description, Property1, Property2, Property3 from Scope() where scope = 'A' or scope='B' or scope='C' doesnt return 75 results ?? it returns 15 or some

FullTextSqlQuery sqlQuery = new FullTextSqlQuery (site); sqlQuery .ResultTypes = ResultType .RelevantResults ; sqlQuery .QueryText = sql ; sqlQuery .TrimDuplicates = true; sqlQuery.EnableStemming=true; ResultTableCollection results = sqlQuery .Execute();