Thanks :) On Apr 10, 5:49 am, Pat Allan <[email protected]> wrote: > Good suggestionTiago- 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,TiagoFrancowrote: > > > Pat, can you had this tip to the thinking sphinx documentation? > > > I think it can be useful. > > > Regards, > > TiagoFranco > > > On Apr 7, 12:25 pm,TiagoFranco<[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. > > >>TiagoFranco > > >> On Apr 6, 11:45 pm,TiagoFranco<[email protected]> wrote: > > >>> Hi, > > >>> I'm having the same issue. Is there a workaround for this? > > >>> Thanks, > >>> TiagoFranco > > >>> 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 > > 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.
