Pat, can you had this tip to the thinking sphinx documentation? I think it can be useful.
Regards, Tiago Franco On Apr 7, 12:25 pm, Tiago Franco <[email protected]> wrote: > Ok, this is how I've done it. > > Create an attribute index based on an SQL snippet (inside define_index > do...end): > > has "CASE WHEN run_time IS NULL THEN 0 WHEN run_time < 30 THEN 1 WHEN > run_time > 30 AND run_time < 60 THEN 2 ELSE 3 END", :type > => :integer, :as => :run_time_mapping > > Then just search by that attribute (i.e. Music.search :with => > {:run_time_mapping => [0,1]} ) > > Hope it helps. > > Tiago Franco > > On Apr 6, 11:45 pm, Tiago Franco <[email protected]> wrote: > > > Hi, > > > I'm having the same issue. Is there a workaround for this? > > > Thanks, > > Tiago Franco > > > On Mar 28, 6:18 am, Pat Allan <[email protected]> wrote: > > > > Hi Lucas > > > > Unfortunately, the only way you can have OR behaviours in filters is > > > searching across multi-value arrays (which are integers).Rangesdon't have > > > this ability. > > > > Sorry - good luck finding a solution that works around this limitation. > > > > -- > > > Pat > > > > On 26/03/2010, at 10:00 PM, Sarniak wrote: > > > > > Hi! > > > > I would like to build such query in sphinx: > > > > > (start_date >= date.today AND start_date <= date.today + 23.hours + > > > > 59minutes) OR (start_date <= date.today AND end_date >= date.today) > > > > > I found usingrangesin shinx like: > > > > > :start_date => 1.week.ago..Time.now > > > > > And I could use it, but only for either first or second part of OR. Is > > > > there possibility to somehow combine two parts of OR statement in > > > > sphinx? > > > > > Regards > > > > Lucas > > > > > -- > > > > 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 > > > > athttp://groups.google.com/group/thinking-sphinx?hl=en. -- 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.
