Good suggestion Tiago - have just done so. http://freelancing-god.github.com/ts/en/common_issues.html#range_or
Cheers -- Pat On 09/04/2010, at 8:20 AM, Tiago Franco wrote: > 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. > -- 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.
