Hi,
I'm using ThinkingSphinx for a new startup website. I'm tried the
above suggestions but am still getting [nil].
The model is called category, and it has a string[100] column called
'name'.
category.rb index code:
define_index do
set_property :group_concat_max_len => 5000
set_property :enable_star => 1
set_property :min_prefix_len => 1
indexes name, :prefixes => true
end
Controller code:
category_results = Category.search params[:term] + '*', :select
=> "name"
I've also tried it without the star at the end, but with no luck. Any
suggestions?
Thanks,
Osman
On Jan 1, 2:39 am, chamroeun ou <[email protected]> wrote:
> Thanks,
>
> Yes, i find the solution.
>
> On 12/28/10, Pat Allan <[email protected]> wrote:
>
>
>
>
>
>
>
> > Hi Chamrouen
>
> > Not sure if you've got this figured out - as far as I can tell, you're using
> > :select correctly. However, you need to use the 'indexes' method inside your
> > define_index block - not 'index'.
>
> > --
> > Pat
>
> > On 25/11/2010, at 7:43 PM, chamroeun ou wrote:
>
> >> I write the following code at the Businesslisting model
>
> >> define_index do
> >> index business_name, :sortable=>true
> >> index service
> >> index description
> >> index district.ename, :as=>:district_name
> >> end
>
> >> -----------Controller Code
> >> Businesslisting.search params[:keywords],
> >> :select=>"business_name,email,telephone"
>
> >> On Thu, Nov 25, 2010 at 2:47 PM, chamroeun ou <[email protected]>
> >> wrote:
> >> Thanks for your quick response
>
> >> We want only specific columns to be populated in the search results
> >> i have tried this
> >> BusinessListing.search "foo", :select => "id, column_a, column_b"
>
> >> But it returned null
>
> >> --------------------
>
> >> I also try indexes location.district_name, :as => :district_name. It
> >> works. But it's a full association not just district_name column. What
> >> we actually want is just the single column.
>
> >> We are using ThinkingSpinx for our CambodiaZoom.com website
>
> >> Chamroeun
>
> >> On 11/25/10, Pat Allan <[email protected]> wrote:
> >> > 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.
>
> >> --
> >> 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.
>
> > --
> > 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.
--
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.
