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?

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


Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Browse other questions tagged or ask your own question.