scrivener_ecto
scrivener_ecto copied to clipboard
drewolson
Paginate your Ecto queries with Scrivener
Below is my implementation I have used order_by condition The data on the first page is fine but when I paginate to other pages I get 1-2 rows every time...
Right now we only can pass `:prefix` repo opt to `Repo.paginate/2` but it should behave like a normal repo operation where the user can pass arbitrary/predefined repo options such as...
Fixes https://github.com/drewolson/scrivener_ecto/issues/99)
Currently, `Repo.paginate` may throw an exception if the query has combinations. Test case: ```elixir Post |> Post.published() |> union(^Post.unpublished(Post)) |> Scrivener.Ecto.Repo.paginate() ``` Exception message: ```shell ** (Postgrex.Error) ERROR 42601 (syntax_error)...
`Repo.paginate(query, pagination_params)` fails with the following error: ``` ** (Postgrex.Error) ERROR 42601 (syntax_error) each UNION query must have the same number of columns query: SELECT count('*') FROM .... (any UNION...
Hi, I've noticed that `allow_overflow_page_number` options works only for pages greater that `total_pages` while querying with a negative page or page 0 still yield the first page. If `allow_overflow_page_number` is...
I'm trying to get records of a table with `page_size: 0` config but it's ignored in the result and the default page size value used. Why `0` would be ignored...
### The Problem The README does not mention options such as :allow_overflow_page_number and direct configuration such as :max_page_size. This is noted in issue https://github.com/drewolson/scrivener_ecto/issues/103 This PR is to (make a...
Thanks for all your work on this package @drewolson. I'm just opening this ticket (and ~~will supply~~ have supplied a [pull request](https://github.com/drewolson/scrivener_ecto/pull/104) with a fix) to improve the libary's documentation....