Hi

Do you want to be able to search by a field in a joined table?



On Jan 25, 11:54 pm, arun <[email protected]> wrote:
> Hi,
> I'm using Thinking Sphinx  in RoR...
>
> There are two tables in db:- users, user_contacts
>
> users table contains the field "user_name"...
> user_contacts contains the fields first_name, last_name etc.
>
> In the search engine, if I enter the User Name then it displays only
> the users records. But for me, it has to display the records from
> user_contacts also by making "Left join with user_contacts table using
> user_id".
>
> This i written in my user_controller...
>
> @search_users = ThinkingSphinx.search "*#{search_text}*", :classes =>
> [User, UserContact]
>
> Can anyone help me to implement....Please tell me what i have to code
> in my user model..?

-- 
You received this message because you are subscribed to the Google Groups 
"Thinking Sphinx" group.
To post to this group, send email to [email protected].
To unsubscribe from this group, send email to 
[email protected].
For more options, visit this group at 
http://groups.google.com/group/thinking-sphinx?hl=en.

Reply via email to