Works!! Thank you On Aug 23, 6:05 pm, Pat Allan <[email protected]> wrote: > You'll want to bring the join in using the 'join' method - unless you're > referring to it normally for other fields/attributes: > > define_index do > # ... > > join B.C # use association names here > has "C.guid", :as => :c_guid, :type => :integer # make sure you're using > the table name in the SQL snippet. > end > > Keep in mind that this will only work if A has_one/belongs_to B, and B > has_one/belongs_to C - otherwise you're going to get multiple C records per A. > > Cheers > > -- > Pat > > On 24/08/2011, at 6:04 AM, jatugade wrote: > > > > > Hi, > > > Say we have three models A, B, C. A is associated with B and B is > > associated with C. I want to index a string column 'guid' in C as an > > attribute of model A. How do I go about doing that? > > > I was trying to do it like this: > > class A > > define_index > > has "CRC32(B.C.guid)", :as => :c_guid, :type =>integer > > end > > end > > > But I'm getting: "Unknown column 'B.C.guid' in 'field list'" > > > Any ideas? Thank you!! > > > -- > > 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 > > athttp://groups.google.com/group/thinking-sphinx?hl=en.
-- 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.
