Rails Persist Search Results to CSV Output

Question

I have a Rails 3.2.x app where I have a reporting controller that does search on the Call model. The code I put together works fine and allows for multiple conditions that will display on the page. The problem I'm having is with exporting the specific search results to a CSV file. So far I've only been able to export the entire database to CSV instead of the specific search results. I'd like to figure out how to get my search params to persist and be able to export only those records to CSV. Here is my relevant code: reports_controller.rb ``` def index @calls = Call.report(params[:search]) respond_to do |format| format.html do @calls = @calls.paginate(:per_page => params[:per_page] || 10, :page => params[:page]).order('incident_number ASC') end format.csv { send_data @calls.to_csv } format.xls { send_data @calls.to_csv(col_sep: "	") } end end ``` Call.rb ``` def self.report(search) search ||= { type: "all" } # Determine which scope to search by results = case search[:type] when "open…

Accepted Answer

In your `Call#to_csv` method you have:

```
all.each do |call|
        csv << [call.id, call.caller_name, call.caller_phone, call.created_at, call.call_status, call.incident_number, call.nature.determinant, call.service_level.level_of_service, call.patient_name, call.patient_age, call.patient_sex.sex, transfer_from_name(call), transfer_to_name(call), call.insurance.insurance_type, call.transfer_date, call.units.map(&:unit_name).join(", "), call.imx_num]
      end
```

I'm thinking the `all` is what is loading up the entire data-set, not your filtered version.

How about passing in the actual rows to convert to CSV, like:

```
def self.to_csv(records = [], options = {})
    CSV.generate(options) do |csv|
      csv << ["Call ID", "Caller Name", "Caller Phone", "Call Created At", "Call Status", "Incident Number", "Diagnosis", "Service Level", "Patient Name", "Patient Age", "Patient Sex", "Transfer From", "Transfer To", "Insurance", "Transfer Date", "Unit", "IMX Number"]
      records.each do |call|
        csv << [call.id, call.caller_name, call.caller_phone, call.created_at, call.call_status, call.incident_number, call.nature.determinant, call.service_level.level_of_service, call.patient_name, call.patient_age, call.patient_sex.sex, transfer_from_name(call), transfer_to_name(call), call.insurance.insurance_type, call.transfer_date, call.units.map(&:unit_name).join(", "), call.imx_num]
      end
    end
  end
```

And then updating your controller:

```
format.csv { send_data Call.to_csv(@calls }
```

Rails Persist Search Results to CSV Output

Solution

Problem