Hmm, I have a test for date columns... odd.
At least to_i is covered.
Cheers
--
Pat
On 22/01/2009, at 3:03 AM, Jeremy Peterson wrote:
> I upgraded ts and it takes care of the .to_i. However I still need
> to explicitly call :type => datetime. I think this is because I am
> using just a date field.
>
> Sweet,
>
> Jeremy
>
> On Tue, Jan 20, 2009 at 10:02 PM, Pat Allan <p...@freelancing-
> gods.com> wrote:
>
> Hi Jeremy
>
> In the latest versions of Thinking Sphinx, you shouldn't need the
> explicit :type => :datetime - and you also shouldn't need .to_i for
> the range arguments. If you're using the latest and it's not working,
> then we can investigate further - but good to know you've got
> something that does the job at the moment.
>
> Cheers
>
> --
> Pat
>
> On 21/01/2009, at 5:07 AM, Finding_Zion wrote:
>
> >
> > 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
-~----------~----~----~----~------~----~------~--~---
