I am using mongodb and using cursor pagination. I am trying to use orders to sort the data I am getting. When I sort by _id I get correct data without any problem. When I start sorting, for example, by the created_at field, then I get the first page correct, and then emptiness, and there is no link to the previous page.
My code:
$sort = $request->get('sort');
$data = User::orderBy($sort, 'desc')->cursorPaginate(10);
What is the problem and how to solve it?
from the docs (https://laravel.com/docs/10.x/pagination#cursor-vs-offset-pagination):
It requires that the ordering is based on at least one unique column or a combination of columns that are unique. Columns with null values are not supported.
seems like the created_at is the problem, since i suppose it is not unique
Please or to participate in this conversation.