Find result from joining a table in rails :conditions part

Question

Currently the attachments are searched based on attachment_file_name, tags and employee_id, I would like to search based on Employee name as well, how can I go with it? Two models must be used.

Employee - which has name of employee
LessonplanAttachment - contains the id of the employee.

The code part.

def search_ajax
   @attachments = LessonplanAttachment.find(:all,
    :conditions => ["attachment_file_name LIKE ? OR tags LIKE ? OR employee_id = ?",
      "#{params[:query]}%","#{params[:query]}%",params[:query]])
end

Can you confirm what version of rails you are using if you are getting undefined method `joins` for your class? — Shadwell, Jul 23 '13 at 12:20

score 0 · Answer 1 · answered Jul 23 '13 at 10:22

0

try this

LessonplanAttachment.joins("JOIN employee on employee_id").find(:all, :conditions =>
  ["attachment_file_name LIKE ? OR tags LIKE ? OR employee_id = ? OR employee.name = ?",
  "#{params[:query]}%","#{params[:query]}%",params[:query], params[:query]]

answered Jul 23 '13 at 10:22

Slicedpan

4,995
2
18
33

undefined method `joins' – Nithin Jul 23 '13 at 10:54
is LessonplanAttachment a subclass of ActiveRecord::Base? – Slicedpan Jul 23 '13 at 11:14

score 0 · Answer 2 · answered Jul 23 '13 at 10:22

0

I guess you have the following association in your LessonplanAttachment model.

belongs_to :employee

Now you can change your code as per the following

@attachments = LessonplanAttachment.joins([:employee]).where("attachment_file_name LIKE ? OR tags LIKE ? OR employee_id = ? OR employees.name LIKE ?", "#{params[:query]}%","#{params[:query]}%",params[:query],"#{params[:query]}%")

answered Jul 23 '13 at 10:22

Bachan Smruty

5,686
1
18
23

undefined method `joins' – Nithin Jul 23 '13 at 10:55

score 0 · Answer 3 · answered Jul 23 '13 at 13:20

Provided you have an association belongs_to :employee on your LessonplanAttachment class, for rails 2, you can add a :joins attribute to the options on find. Something like this should work:

@attachments = LessonplanAttachment.find(:all,
 :joins => :employee,
 :conditions => [
   "attachment_file_name LIKE ? OR tags LIKE ? OR 
    employee_id = ? OR employees.name LIKE ?",
   "#{params[:query]}%","#{params[:query]}%",params[:query],"#{params[:query]}%"])

Find result from joining a table in rails :conditions part

3 Answers3