Hi,
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:
Application.paginate(:all,
:conditions =>
[(["(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,
Ryan Lundie
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"Ruby on Rails: Talk" group.
To post to this group, send email to
rubyonrails-talk-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org
To unsubscribe from this group, send email to
rubyonrails-talk-unsubscribe-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org
For more options, visit this group at
http://groups.google.com/group/rubyonrails-talk?hl=en
-~----------~----~----~----~------~----~------~--~---
