Pragmatic Studio Liveview course pagination lesson - giving me different numbers of items

Hello! I am working on the Pragmatic Studio Phoenix Liveview course and am on the pagination lesson. When I go to the next page, it is giving me different numbers of items on each page each time I click through. I am trying to get it to give me a drop down(which I have) of 5, 10, 15, and 20 items and depending on what I click on it will show that amount of items on every page. Any suggestions of why it is just giving me a random number of items

Can you show us what your code looks like so far? Specifically the code from your paginate_live.ex, and maybe also the list_donations/1 query from donations.ex?

Thank you. Here is the paginate_live.ex file

defmodule LiveViewStudioWeb.PaginateLive do
use LiveViewStudioWeb, :live_view

alias LiveViewStudio.Donations

def mount(_params, _session, socket) do
paginate_options = %{page: 1, per_page: 5}
donations = Donations.list_donations(paginate: paginate_options)

socket =
  assign(socket,
    options: paginate_options,
    donations: donations
  )

{:ok, socket, temporary_assigns: [donations: []]}

end

def handle_params(params, _url, socket) do
page = String.to_integer(params[“page”] || “1”)
per_page = String.to_integer(params[“page”] || “5”)

paginate_options = %{page: page, per_page: per_page}
donations = Donations.list_donations( paginate: paginate_options)

socket =
  assign(socket,
    options: paginate_options,
    donations: donations
  )

{:noreply, socket}

end

def handle_event(“select-per-page”, %{“per-page” => per_page}, socket) do
per_page = String.to_integer(per_page)
socket =
push_patch(socket,
to: Routes.live_path(
socket,
MODULE,
page: socket.assigns.options.page,
per_page: per_page
))

{:noreply, socket}

end

defp expires_class(donation) do
if Donations.almost_expired?(donation), do: “eat-now”, else: “fresh”
end

defp pagination_link(socket, text, page, per_page, class) do
live_patch text,
to: Routes.live_path(
socket,
MODULE,
page: page,
per_page: per_page
),
class: class
end

end

Here is the list_donations query. Thank you again!

def list_donations(criteria) when is_list(criteria) do
query = from(d in Donation)

Enum.reduce(criteria, query, fn
  {:paginate, %{page: page, per_page: per_page}}, query ->
    from q in query,
      offset: ^((page - 1) * per_page),
      limit: ^per_page

  {:sort, %{sort_by: sort_by, sort_order: sort_order}}, query ->
    from q in query, order_by: [{^sort_order, ^sort_by}]
end)
|> Repo.all()

end

That is not right, it might be why You have not the right number of records :slight_smile:

Thank you! I just fixed it to read per_page and it worked :slight_smile: