Use filters and paginate

[Barbapapazes]

Hello,

My problem is the following:

How to pass the query string from one query to another using pagination?

Indeed, my page has filters that will alter the query string. My pagination resets to 1, it's perfect.

But if I want to access page 2, using the getUrlsForRange method, then I lose all the filters. I can use the baseUrl with a request.url(true) but the problem is that the page is added afterwards giving me the following url:

/?lorem=ipsum?page=2 # But the second ? is not necessary and breaks the request

The question is : How to set up a filtration with a pagination allowing to change page while keeping the filters ?

[Barbapapazes]

https://github.com/adonisjs/lucid/blob/develop/src/Database/Paginator/SimplePaginator.ts#L144

This is the place where the mandatory addition of the ? takes place without taking into account an already existing qs.

[Barbapapazes]

I think getUrlForRange could take qs in a third parameter ?

[Barbapapazes]

or maybe baseUrl could take the query string and apply it in the function getUrl ?

[Barbapapazes]

So, after deep diving in the source code, I discover queryString which is exactly what I need!

const { page = 1, ...qs } = request.qs()

const profiles = await Profile.query()
  .filter(qs)
  .preload('focusInterests')
  .preload('role')
  .paginate(page, this.PER_PAGE)

profiles.baseUrl(request.url()).queryString(qs)

return view.render('pages/mee/index', { profiles })

I will check if I can find this method in the documentation, otherwise, I make a PR!

[Barbapapazes]

I found It : https://docs.adonisjs.com/reference/database/query-builder#querystring
But maybe more docs on this use case could be cool!