400 error occurs when using the search function while on page 2 or later in pagination

[haruki-hiraiwa]

If I use the search function while on page 2 or later in pagination, I get a 400 error.
I think this is probably due to the second page not existing in the search results.

I did not see this error with sqladmin version 0.16.1, but with version 0.17.0.
So I think the error is due to the version of the library.

↓No error
sqladmin = {extras = ["full"], version = "^0.16.1"}
↓Error
sqladmin = {version = "0.17.0", extras = ["full"]}

[aminalaee]

Hi, yeah you are right, might be related to #782
PRs are welcome to fix this

[rvic]

Never did PRs before. As working solution I had to override list() method of ModelView in my custom view. Copied method body from current sqladmin/sqladmin/models.py.

And then just replaced

       search = request.query_params.get("search", None)

with

       search = request.query_params.get("search", None)
       if search and search != "" and page > 1:
            page = 1

This resets current page to first whenever you are trying to search something. If you typically have more than one page of search results then this solution wouldn't have much value for you.