Sharepoint Online - CSOM search KeyWordQuery document not appear

Question

Hello,

I'm doing a search in Sharepoint with CSOM, some documents are missing, otherwise if a do the same search directly over Sharepoint this documents appear....

I already check Query Source, crawled properties, syntax, etc... need help.

=======================

			KeywordQuery keywordQuery = new KeywordQuery(lContext)  
			{  
				QueryText = lsQuery,  
				SourceId = new Guid("21a5d2a0-e739-48a7-948d-deeb5f705f48"),  
				StartRow = liStartAt, RowLimit = liRowLimit  
			};  
            QueryPropertyValue lValue = new QueryPropertyValue();  
            lValue.StrVal = "Documentos";  
            keywordQuery.Properties.SetQueryPropertyValue("SourceName", lValue);  
            lValue.StrVal = "SPSiteSubscription"; //tenant level  
            keywordQuery.Properties.SetQueryPropertyValue("SourceLevel", lValue);  

=======================

Using the same syntax that in the print screen, KeyWordSearch returns nothing....

Thanks a lot,

Mauricio.

Answer 1

Hi @Mauricio Poggio Veiro ,

This could be some rows / items are incorrectly treated as duplicates by search.

Try to add keywordQuery.TrimDuplicates = false; in your code, check if it works for you.

---

If an Answer is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

Answer 2

Hi @Mauricio Poggio Veiro ,

Please try to use the below CSOM code, check if it work for you:

string username = "michael";  
string pwd = "password";  
string siteURL = "https://tenant.sharepoint.com/yoursite";       
ClientContext context = new ClientContext(siteURL);  
SecureString pass = new SecureString();  
foreach (char c in pwd.ToCharArray()) pass.AppendChar(c);  
context.Credentials = new SharePointOnlineCredentials(username, pass);  
KeywordQuery query= new KeywordQuery(ctx);  
query.QueryText = "IdSeguimientolni=604068";  
SearchExecutor search = new SearchExecutor(context);  
ClientResult<ResultTableCollection> results = search.ExecuteQuery(query);  
context.ExecuteQuery();  

---

If an Answer is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

Answer 3

Hi Michael,

I already try security issues, but I tried your example and throw this error:

"'=' is an unexpected token. The expected token is ';'. Line 1, position 434."

thanks a lot!
Mauricio.

Answer 4

Forget my last post.

Now I could get the document, this is my code:

        KeywordQuery keywordQuery = new KeywordQuery(lContext)
        {
        QueryText = lsQuery,
        SourceId = new Guid("BLABLABLABLA"),
        // HOUSTON!! StartRow = liStartAt, 
        RowLimit = liRowLimit
        };
        QueryPropertyValue lValue = new QueryPropertyValue();
        lValue.StrVal = "Documentos";
        keywordQuery.Properties.SetQueryPropertyValue("SourceName", lValue);
        lValue.StrVal = "SPSiteSubscription"; //tenant level
        keywordQuery.Properties.SetQueryPropertyValue("SourceLevel", lValue);

     

If I comment "StartRow" then I get the expected result....

But now I have another strange behavior:

If I filter with "IdSeguimientoIni=604126" then I get the documento, but if I filter with "isdocument:1 AND (FileName<>index.aspx) AND IdCliente=100000 TemaId=14964 " then this document is missing (I get nine documents, 7 are missing).
I did the same search directly in sharepoint site search box and I get the fifthing documents, so I may suppose that is not a crawler problem......

thanks!
Mauricio.

Answer 5

Excelent Michael!! thanks!

Now I should find out why I get 7 documents more than in my Sharepoint onpremises :)

cheers!
Mauricio.