Unable to get the data from DB in a required format using Rails-CodePudding

The

In the image the data for the second is not matching up with the header above what I mean is the "okay" belongs to the "E" in the header, "90" belongs to "M" in the header

CodePudding user response：

You could do something like this (It's not very clear what you mean):

appointments.includes(results: :investigation).map do |app| [app.investigation_date.strftime("%d-%b-%Y"), app.results.map(&:findings)] end.to_h

CodePudding user response：

I would suggest to use each_with_object

# includes are for eager loading appointments = Appointment.where("patient_id = ? and investigation_date IS NOT NULL", params[:p_id]) .includes(results: :investigation) .order("investigation_date desc") .limit(5) final_obj = appointments.each_with_object({}) do |app, obj| date = app.investigation_date.strftime("%d-%b-%Y") obj[date] = app.results.map{|data| data.findings } end

Note: I have no idea what is findings and why you first included investigation. If you add model associations, I might update my solution.

CodePudding user response：

This is the best I came up with:

investigations > | .name | .name . . appointments |------------------- v | | .investigation_date | results | results .investigation_date | results | results . . . .

Make an array of investigations you want to display. Use it to make the header and then use the same array to get the matching results from each appointment. Then you can pull any information from those results, like, findings.

investigations = Investigation.order(:name) table = [["Date", *investigations.pluck(:name)]] table << Appointment.includes(results: :investigation).map do |a| [ a.investigation_date, *investigations.map do |investigation| a.results.select { |r| r.investigation_id == investigation.id }.map(&:findings) end ] end

I assume you could have more than one investigation on the same day, so this doesn't work and will overwrite existing dates:

data[app.investigation_date.strftime("%d-%b-%Y")] = result