UltraSphinx for Rails

help me please to solve it:

i have the following configuration of UltraSphinx:

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

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.

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.