I have the following structure with my models:
A member inherits from a company
A applicant inherits from a company
An application has an applicant
An application has a member
I am attempting to do a find on the applications table where the
search term either matches the applicant name or the member name.
So far I have the following find statement:
[(["(LOWER(companies.name) LIKE ?)"] * terms.size).join(" AND "), *
terms.flatten], :include => [:applicant, :member], :per_page =>
10, :page => page, :order => 'applications.id desc')
It seems as if rails creates the first join in sql normally, but then
creates the second join and gives it the name: members_applications. I
could just add the condition or members_applications.name like ... but
I don't think this is the proper way of doing things.
Another option is to do it in multiple find statements, but I don't
think this is correct either.
Does anyone have a suggestion?
Thanks for your help,