tvainika / objection-keyset-pagination Goto Github PK

Hi,
This is not an issue, a noob question!
Thanks for the this package. I want to show pagination with vuejs with express backend.
I am getting

"paginate": {
"first": 1,
"last": 10
}

this object. How can i navigate to the next page?

Can i get a response something like that?

   "current_page": 1,
    "last_page": 3,
    "next_page_url": "/api/animals?page=2",
    "prev_page_url": null,

Cool lib, I think the concept is good, unfortunately it doesn't seem to work :/

Tried using this on a small project, using a simple query:

await ModeNamel.query()
    .limit(N)
    .keysetPage()

but result.keyset is always equal to: { first: {}, last: {} }

Hi, so what is happening with me is

fetch 1 (ok)

.orderBy('id') => keyset { first: 3, last: 6 }

fetch 2 (fail)
error: column reference "id" is ambiguous"

(so it can't get the 2nd page)

fetch 1 (fail)

.orderBy('profile.id') => keyset {}

(if I try to define it, keyset returns empty)