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();
