Inconsistencies observed in UI responses when executing queries with offset and limit parameters.
I have more than 50000 data in db.
For eg:
When offset to set to 100 and limit to 100, response returned is single instance.
When offset to set to 99 and limit to 100, response returned only 2 instances.
When offset to set to 98 and limit to 100, response returned only 3 instances.
Whenever offset is set above limit it return nothing.
However, calling the API with the same query consistently provides the correct response, delivering the expected 100 records starting from the specified offset.
Inconsistencies observed in UI responses when executing queries with offset and limit parameters.
I have more than 50000 data in db.
For eg: When offset to set to 100 and limit to 100, response returned is single instance. When offset to set to 99 and limit to 100, response returned only 2 instances. When offset to set to 98 and limit to 100, response returned only 3 instances.
Whenever offset is set above limit it return nothing.
However, calling the API with the same query consistently provides the correct response, delivering the expected 100 records starting from the specified offset.