I have Job and Feedback models.
They are associated like this:
Job has_many :feedbacks
Feedback belongs_to :job
I'm trying to make a query to get jobs which have NO feedbacks with feedback.user_id == job.client_id
4 Answers
jobs=Job.find(:all, :select => 'DISTINCT id', :order=>"id asc").map { |n| n.id.to_s })
feedbacks=Feedback.find(:all, :select => 'DISTINCT job_id', :order=>"job_id asc").map { |n| n.job_id.to_s })
jobs_without_feedbacks=jobs-feedbacks
ok. then try this. it might work good in your case. jobs_without_feedbacks will be the array of ids of the job with no feedback.
1 Comment
vladzaets
I don't need
jobs without ANY feedbacks. I need jobs without feedbacks with user_id == job.client_id. If job has feedbacks with any other user_id – it's OK.jobs=Job.all
no_feedback_jobs=Array.new
jobs.each do |job|{ (no_feedback_jobs<< job) if !job.feedback}
Try this .It will work fine
1 Comment
vladzaets
That works but I want to do it in the database, because it will be very slow if I have a lot of records.
feedbacks = Feedback.map(&:user_id).uniq
User.includes(:jobs => :feedbacks).where.not(:client_id => feedbacks).where(:id => current_user.id)
Try this
7 Comments
vladzaets
I suppose this is the same.
jobs_as_worker = current_user.jobs_as_worker.includes(:feedbacks).where{client_id.not_in Feedback.select{user_id}.uniq} This code works but not in the way I need. I need to use not all feedbacks in databse – Feedback.select{user_id}.uniq, but feedbacks only for a specific job, like jobs.feedbacks.select{user_id}.uniq – but I can't make this work.vladzaets
No, I want jobs which have NO feedbacks with
feedback.user_id == job.client_id
Vrushali Pawar
Then in your code why you have written current_user.jobs_as_worker?
vladzaets
I want
jobs that belong to current_userVrushali Pawar
I was asking the same question
|
This uses two queries, but the pluck should be relatively light.
Job.includes(:feedbacks)
.where(feedbacks: {id: nil})
.where.not(client_id: Feedback.pluck(:user_id))
6 Comments
vladzaets
What
.where(feedbacks: {id: nil}) means? How id could be nil?fylooi
Job.includes(:feedbacks).where(feedbacks: {id: nil} returns jobs which do not have feedbacks.vladzaets
This query returns Jobs where its client has feedbacks. I need Jobs where it's client didn't get feedback for this specific job.
vladzaets
I need something like this:
.includes(:feedbacks).where(feedbacks: {id: nil}).where.not(feedbacks: {user_id: job.client_id}) – but I can't make it work.fylooi
How about adding a
not to the last line? |
jobs_as_worker = current_user.jobs_as_worker.includes(:feedbacks).where{client_id.not_in Feedback.select{user_id}.uniq}