UltraSphinx for Rails

rubyonrails-talk
1

help me please to solve it:

i have the following configuration of UltraSphinx:

2

Your UltraSphinx setup and the returned columns of a query have nothing to do with each other.

The US setup only defines how US should query the database to git it's index values

is_indexed :fields => [first_name, last_name, e_mail],              :delta => {:field => "updated_at"}

would be all you need in your User model

@search = Ultrasphinx::Search.new(:query => 'kjhui') @users = @search.run

should return the full set of columns in the users table

3

Thorsten Mueller wrote:

Your UltraSphinx setup and the returned columns of a query have nothing to do with each other.

The US setup only defines how US should query the database to git it's index values

is_indexed :fields => [first_name, last_name, e_mail],              :delta => {:field => "updated_at"}

would be all you need in your User model

@search = Ultrasphinx::Search.new(:query => 'kjhui') @users = @search.run

should return the full set of columns in the users table

thanks for answer, 1) but how can i get data from other tables(my_prof, my_country, my_space, my_languages)?(I want to get data near as SQL query(that i write in config/ultrasphinx/development.conf) is returned) 2) Can US also returned data from users, my_prof, my_country, my_space, my_languages also?

How can i implement this?

Help me please to solve it problem.

4

thanks for answer, 1) but how can i get data from other tables(my_prof, my_country, my_space, my_languages)?(I want to get data near as SQL query(that i write in config/ultrasphinx/development.conf) is returned) 2) Can US also returned data from users, my_prof, my_country, my_space, my_languages also?

How can i implement this?

Help me please to solve it problem.

I'm also wondering about this.

Is there a way to return which field(s) the search word is found in for each User? I've been looking, but have not found a way to do this.