Hey Pat,
I have been wrestling with an outsourced project that they brought back in
house. They used Thinking Sphinx, without giving any documentation or
comments in their code about how they set things up or what they were
trying to achieve. After months of hacking away at this app, its 95%
finished. The last part I am having difficulty fixing is getting the search
to constrain the results correctly. I am super new to this and would
appreciate any insight you could give me. So here is my issue on
stackoverflow<http://stackoverflow.com/questions/14616987/thinking-sphinx-search-using-with-and-indexed-attributes>,
and I will elaborate below as well.
So basically the issue is between 3 models/tables users, bars and
bar_profiles. There are bar_profiles for each bar, that contains the
criteria we are matching against the users criteria. There is a bar_profile
for each day, containing the criteria to match against for the users
selections.
Inside bar is where the search is happening so they set up indexes for
bar_profiles as follows:
has_many :bar_profiles
define_index do
has bar_profiles(:day), :as => :days
indexes bar_profiles.budget, :as => :budget_tags
indexes bar_profiles.day, :as => :day
indexes bar_profiles.tags, :as => :daily_tags
.
.
end
and in the method that runs the search I have:
today = ((Time.now + Time.zone_offset('EST')).strftime("%A")).downcase
search_options = {:conditions => {}, :with => {:days=>today}, :page =>
1, :per_page => algorithm.results_per_page}
search_options[:conditions][:experience_tags] = options[:experience]
unless options[:experience].blank?
budget = combine_budgets(options[:budget])
search_options[:conditions][:budget_tags] = budget unless budget.blank?
What I am trying to do is match the options[...] that the user selects
against the bar_profile that matches up with the current day. The current
set up allows the search to run without errors using:
bars = Bar.search(search_options)
But when I added in the :with=> {:days=>today}, I stopped getting any
results back from the search. So I am guessing I just don't fully
understand how to use 'with' in Thinking Sphinx for my exact
implementation. What I am trying to do is make the search constrain the
results based on the current day.
Where my goal would be if I don't pass in any conditions, it would return
all the bars with a profile for today. If I have a condition for budget_tag
= low budget, I only want to get back bars that have a bar_profile for
today that contains that budget_tag.
Currently without the 'with' option it will return any bar that has ANY
bar_profile that has one of the match criteria. So I am getting a bar that
has the criteria, but for the wrong day.
If you could help guide me to some examples or give some insight I would
really appreciate it. I have been wrestling with this issue for a week now
and I have gotten to this point but still can't seem to get the
functionality I need. I know I am doing something wrong, I just don't
really understand how to correct it. Either way I appreciate you taking the
time to read this.
Thanks,
Alan
--
You received this message because you are subscribed to the Google Groups
"Thinking Sphinx" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To post to this group, send email to [email protected].
Visit this group at http://groups.google.com/group/thinking-sphinx?hl=en.
For more options, visit https://groups.google.com/groups/opt_out.
