Pagination with dinamic data.

Posted 1 year ago by likvidatorTM

Hi, recently i used eloquent simple pagination but now i found some critical bug (eloquent method works fine, bug in my solution=)). In query i am use some conditions like if order active, if user can see this order end etc. When user gets next page results can be displaced and he gots incorrect data. For example: user loads first page with 10 orders then he loads second page and 8 of recent orders was marked as "disabled" and response data will contains 2 orders that user already loaded. I cant use coursor pagination because sort field not unique. I see only 1 way to resolve this problem: send from client orders ids that he loaded and then use its in query where NOT IN. P/S its a SPA application.

Please sign in or create an account to participate in this conversation.