Hi Everyone,

I have a kase model which I am using a simple search form in. The problem I am having is some kases are linked to companies through a company model, and people through a people model.

At the moment my search (in Kase model) looks like this:

# SEARCH FACILITY
  def self.search(search)
    search_condition = "%" + search + "%"
    find(:all, :conditions => ['jobno LIKE ? OR casesubject LIKE ? OR transport LIKE ? OR goods LIKE ? OR comments LIKE ? OR invoicenumber LIKE ? OR netamount LIKE ? OR clientref LIKE ? OR kase_status LIKE ? OR lyingatlocationaddresscity LIKE ?', search_condition, search_condition, search_condition, search_condition, search_condition, search_condition, search_condition, search_condition, search_condition, search_condition])
  end

What I am trying to work out, is what condition can I add to allow a search by Company or Person to show the cases they are linked to.

@kase.company.companyname

and

company.companyname

don't work :(

Is this possible?

Thanks,

Danny