Incorrect count of offset pagination return

Hello, I have a situation where the pagination query misses 1 count from the record. I have 153 records in database. But, when i queried them out (with offset and limit = 100), i can only get a total of 152.

I tried both client SDK and server SDK (in case of permission issue). Both gave me the same 152 count instead of 153. Here're all the screenshots.

Would you know why is that so? Thanks.

The second request should have an offset of 100

ah, my bad. Thanks very much @Steven

:sadge: I think I need to revisit the pagination guide

I don't know if the current hardcoded example is the best way

to show how it's intended to be used. Maybe we should also have programmatic examples

Thanks @VincentGe. The sample in the doc is good. it is clearly using "last count." I overlooked it and went with "next count" which is similar to my other project.