database - Rails, search item in different model? -

I have a case model that I am using a simple search form. The problem I have is in some cases

Currently my search (in the Cage model) looks like this:

  # Search feature DEF self search (search) search_condition = " % "+ Search +"% "looks (: all,: position => gt; ['jobno is like or liked casesubject or transport choice or goods like your likes or dislikes or like INVOICENUMBER ????? Like like netamount? Or clientref? Or like kase_status? Or like falseatlocationaddresscity? ', Search_condition, search_condition, search_condition, search_condition, search_condition, search_condition, search_condition, search_condition, search_condition, search_condition] ) End  

What can I add to allow the company or the person to search for those conditions, what am I trying to do?

  @ kase.company.companyname  

and

  company.companyname  

< P> Don 't work: (

Is it possible?

Thanks,

Danny

Edit:

  find (all: conditions => gt; ["like kase.jobno: like q or kase.casesubject: like q or kase.transport: q or company.companyname like: q  
 Case Model:  
  Category Cases & LT; ActiveRecord :: Base is_to: Company # Foreign Key: company_id belongs_to: Person # Foreign key in the join table is_to: Survey "Person",: class_name = & gt; "company" ,: foreign_key => "appointment official_id" belongs_to: survey orperson,: class_name = & gt; "person" ,: foreign_key => "surveyorperson_id"  
 
 kase controller: 
 
  # search feature DEF self.search (search) find_condition = "%" + Search + "%" (Find All:: Status = & gt; [Like 'jobno' or 'casesubject' is like or transport choice or goods like your liking or dislikes or liked INVOICENUMBER or liked the netamount or like clientref or kase_status or like lyingatlocationaddresscity '?????????, Search_condition, search_condition, search_condition, Search_condition, search_condition, search_condition, search_condition, search_condition, search_condition, search_condition]) #search (: all,: position => ["Like kases.jobno: like q or kases.casesubject: like q or kases .transport: like q or kases.goods: like q or kases.comments: q or kases.clientref likes: q or kases Like kase_status: like q or kases.lyingatlocationaddresscity: q or like companies.companyname: q or people. Person name: q ", {: q = & gt; Search_condition}] ,: join = & gt; [: Person, company]) end  
 

You might use Want: joins = & gt; [: Company :: person] option and then : Terms to rewrite 'kase.jobno'? Like ... company.companyname? ... '.

Look like this:

  find (all: conditions => gt; [like "kases.jobno: q or kases.casesubject like: q or kases.transport Like: q or like companies.companyname: like q or people.personname: q ", {: q = & gt; search_condition}], joins =>: [: person,: company])