On 25/11/2010, at 3:11 PM, chamroeun wrote: > I am a rookie in Thinking Sphinx for Rails. > > I am developing a business directory search. I have 2 tables > BusinessListing and Location. > > When Sphinx found a record, it will give all the fields in the table. > How can i select only the needed fields?
Did you want to search on specific fields? Or did you want only specific columns to be populated in the search results? For the first, you'll want to look at the :conditions option: http://freelancing-god.github.com/ts/en/searching.html#conditions And read up on extended search syntax for more complex situations: http://www.sphinxsearch.com/docs/manual-0.9.9.html#extended-syntax For just specific columns (ie: ActiveRecord's :select option), you can just use :select in a search query, and it gets passed through to the underlying ActiveRecord::Base.find request: BusinessListing.search "foo", :select => "id, column_a, column_b" > And in another case, i also need reference to another > table(Businesslisting=>Location(district name). i need to retrieve the > district name to include in the resultset of businesslisting. how can > i do that? To include columns from associations in your indexes, you can just refer to the associations in your define_index block: define_index do # ... indexes location.district_name, :as => :district_name # ... end Cheers -- Pat -- 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.
