I figured out what the problem was with the way I set up the index. I
had to set the type to datetime, perhaps it has to do with my database
table using a date type.
In the model:
has data.pub_date, :type => :datetime, :as => :pub_date
Searching:
def advanced_search
conditions = filter_type
search = params.dup.delete_if {|k,v| !"title author id cb_number
season isbn".include? k}# List items to include
search.each do |key, value|
conditions[key.to_sym] = value if !value.blank?
end
# Search Date range
if !params[:pub_date][:start].blank? && !params[:pub_date]
[:start].blank?
start_date = params[:pub_date][:start].to_i
end_date = params[:pub_date][:end].to_time.advance(:days =>
1).to_i
conditions[:pub_date] = start_date..end_date
end
Project.search :include => :data,
:conditions => conditions,
:page => params[:page] || 1,
:order => "title asc",
:per_page => 10,
:match_mode => :extended
end
On Jan 20, 12:28 pm, Finding_Zion <[email protected]> wrote:
> I need to add a range search for dates. The usage guide mentions that
> dates are converted to timestamps, however it would be nice to have
> some examples for how to search them. This is what I have so far and
> it isn't search the way I'd expect.
>
> In the model:
> indexes data.pub_date, :as => :pub_date
>
> Phase 1 (Search for a date field)
> When searching, I add the following condition.
> :conditions => {:pub_date => "8/31/2008".to_time.to_i}
>
> This should be an exact match for 4 records.
>
> Phase 2 (Search for a range and my ultimate goal)
> I need to take this and search for a range. According
> tohttp://stackoverflow.com/questions/355937/filtering-sphinx-search-res...
>
> I should be able to do a range like:
>
> :conditions => {:pub_date =>
> "8/1/2008".to_time.to_i.."9/10/2008".to_time.to_i}
>
> How can I fix this?
--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---
