pagy | 🏆 The Best Pagination Ruby Gem 🥇 | Application Framework library

Your code should say Task.ransack(name_cont: params[:q][:name]) because your params look like this: {"q"=>{"name"=>"TT"} }.

But, you are using the same action, index to render the intial page (when the user lands on it) and also after Search is pressed. When the page renders first, i.e http://localhost/tasks, q parameter does not exist and writing params[:q][:name] will obviously fail because params[:q] is nil.

Ideally, you should keep index to render the search form and have another action for search.

But, if you want to keep everything as is you could write it as follows:

Assuming you have a TasksController:

First of all: your code is extremely inefficient because:

1. It does 3 queries instead of 1
2. It pulls all the records into memory (potentially crashing your server) and joins them into an array using yet more memory to create another possibly huge object
3. It uses pagy_array, that should never be used that way

So let's start to change that.

1. Do not use + but create a single scope that ORs the 3 scopes (gold, silver, plan) together (that should be AR relations too, not literal queries). That will get you a single AR Relation not loading anything into memory yet
2. Use the AR Relation directly with pagy instead of pagy_array: that will pull only the page of records that you are going to need, not the whole bunch of records that you don't need
3. Use the same AR Relation for pagy_meilisearch and your problem will probably disappear without further changes. If it won't, then look into your scope.

Rather than having separate routes for each movie filter, you could specify the filter with a query param to Movies#index

so I'm happy I came across this post. I have been using kaminari for years and had no idea about pagy and now I'm excited to try it!

My experience is with kaminari, so I had to google usage with pagy. It looks like to me you need to pass the entire query to the pagy method.

ie:

@pagy, @patients = pagy(Patient.ransack(params[:q]).result(distinct: true))

Hopefully that works!

You are trying to call model_name on an Array model_name is a method of a ActiveRecord of ActiveRecord::Relation. You did not supply the code where you call the pagy_get_vars(collection, vars) method but you need to make sure that collection is some object type that has a model_name method like an ActiveRecord::Relation and not an Array.

Perhaps the problem is started here:

The problem is right here:

you could use select MAX each group instead oforder DESC

As you have namespace in routes, you need to specify that with form_with

You can put this in the pagy initializer: