On 29 Set, 20:18, Matt Jones <[email protected]> wrote:
> On Sep 29, 5:18 am, adedip <[email protected]> wrote:
>
>
>
> > Hi everybody...
>
> > I'm getting crazy to understand how to make things working..
> > I have to use both Solr and rails Find to filter search result, and I
> > realized that the only option is to get the ids from the different
> > search results..and then intersect the array of the ids.
>
> > Once did this..I can't make find_all_by_id work passing the resulting
> > array as parameter, I have this:
> > ----
> > In this way I get no error, but no results.
>
> > aut = params[:article][:author]
> > @aut = Article.find(:all, :conditions => {:author => aut})
>
> > from = params[:from][:date]
> > to = params[:from][:date]
> > @range = Article.find(:all, :conditions => {:date =>from..to})
>
> > query = params[:query]
> > @search = Article.find_by_solr(query).results
>
> > ids = Array.new
>
> > @aut.each { |item|
> > ids.push(item.id) }
>
> > @range.each { |item|
> > ids.push(item.id) }
>
> > @search.each { |item|
> > ids.push(item.id) }
>
> > @temp = ids.to_set
> > @ids = @temp.to_a
>
> > @articles = Article.find_all_by_id([...@temp])
> > ----
> > using �...@articles = Article.find_all_by_id(@temp)
> > I got error saying:
> > Mysql::Error: Operand should contain 1 column(s): SELECT * FROM
> > `articles` WHERE (`articles`.`id` =
> > 115,159,78,101,129,19,80,20,70,136,48,54)
> > ----
> > using @articles = Article.find_all_by_id(@ids)
> > It seems to work, I get results, but they're wrong! :S
>
> Um, maybe they are wrong because you haven't computed the intersection
> of the arrays above - you've found the union.
>
> Note that it should work to do this:
>
> proxy = Article.scoped(:conditions => { :author => params[:author] })
>
> from = params[:from][:date] # may need .to_date here
> to = params[:to][:date] # I'm assuming there was a typo in the
> original
> proxy = proxy.scoped(:conditions => { :date => from..to })
> @articles = proxy.find_by_solr(params[:query])
>
> The .results on the original find_by_solr is confusing; are you using
> an old version?
>
> Acts_as_solr doesn't 100% support scoping like this, but digging
> around in the underlying code shows that the actual results are loaded
> with a find(:all, :conditions => { :id => results }), which will apply
> the other constraints.
>
> --Matt Jones
Hey Matt, I hope I understood what you wrote..if so that might be
amazing! I'll try it tomorrow, i didn't know about old version
of .results, so what should I use instead? nothing? just find_by_solr
(params[:query])
I'll let u know! Thanks!
@Fred, yes, you're right :)
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups "Ruby
on Rails: Talk" 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/rubyonrails-talk?hl=en
-~----------~----~----~----~------~----~------~--~---
