I am running a search for a particular query that I want to export the documents from.

When I run the query I base the total count on the TotalRowsIncludingDuplicates property as I want all items including any duplicates (this is the number actually displayed in the search centre when you run a search). When I look at the TotalRows property it tends to be quite a bit smaller.

I page the query using RowLimit and StartRow while TotalResults <= TotalRowsIncludingDuplicates. When I get to the TotalRows value the remaining queries up to TotalRowsIncludingDuplicates return 0 results.

I can't explain this discrepancy as I would expect to see the full duplicate result number. In some cases there is a delta of over 1k items.

Can anybody explain this please?

| improve this question | | | | |
  • 2
    If you are in control of the query, the TrimDuplicates property should solve your problem – Mx. Jul 6 '17 at 9:44
  • Yeah, thanks I'm an idiot. It seems that it is true by default. – Bunzab Jul 6 '17 at 10:49

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.