Total Count is varying with the pagingInfo batch size

Question

Hi Contributors, 
 I have created a query entity to query a view and strangely I observe that the total count varies with the batch size of the paging info. 
 
 Scenario 1 : Total Count : 379 
 a!pagingInfo( startIndex: 1, batchSize:-1 ) 
 Scenario 2 : Total Count : 373 
 a!pagingInfo( startIndex: 1, batchSize:20 ) 
 Strange but true ! 
 The correct value I should be expecting on every evaluation irrespective of the batch size is 379 . 
 Awaiting your comments .

Josh · Accepted Answer

This is probably due to your primary key not being unique. If you run a distinct query on the primary key column in the database, you will get 373.

Total Count is varying with the pagingInfo batch size

Top Replies