SharePoint Online Provider Hosted - No Search Results

Question

Hi I'm having trouble with my provider hosted app.

I've created an app which mostly works, but the search whilst I could have sworn was working now gives me no results.

My code is thus.

KeywordQuery keywordQuery = new KeywordQuery(_sp);
 keywordQuery.QueryText = "Test*"

 keywordQuery.StartRow = 0;

SearchExecutor searchExecutor = new SearchExecutor(_sp);

ClientResult<ResultTableCollection> results = searchExecutor.ExecuteQuery(keywordQuery);
 _sp.ExecuteQuery();

and it all works and compiles, but no results. The site works fine, if I try the REST API though a test tool and Postman, that works fine. But this does not.

Any ideas on how to fix this?

Answer 1

Hi @Housham Richard - Systems Developer ,
Please check the permission of the user to the results. Then 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 the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".
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

Ok, long story short there is a problem in creating a site app categlog for a ste collection.
https://www.c-sharpcorner.com/article/enable-site-collection-app-catalog-for-particular-site-collection-level-solution/

This seems to create some problems with duplicate fields and then knackers up a few fields - by creating duplicates (just what our systems team told me). This then knackers up calculated fields form page and this search tool.

Deleting the fields solves the problem.