sure. I'm happy to take some load off Pat's shoulders :D On Wed, Aug 4, 2010 at 11:08 AM, alex <[email protected]> wrote:
> uuuhhh! It works perfectly! > > Thank you so much for the help! > Have a great day. > > Cheers, > Alex > > > On Aug 3, 7:56 pm, Jim Ruther Nill <[email protected]> wrote: > > you can add an attribute like > > > > has 'day_of_week is NULL', :as => :no_event, :type => :boolean > > > > then add in your search > > > > Model.search :with => {:no_event => false} > > > > > > > > > > > > On Wed, Aug 4, 2010 at 10:52 AM, alex <[email protected]> > wrote: > > > Hey Pat, > > > > > Thanks for your reply! > > > > > From your explanation, I understand where my problem comes from: > > > Some courses are not associated to any event... so when I search for > > > courses associated to events with day_of_week = 0 it also returns the > > > courses that are not associated to any event. > > > > > Is there any workaround so that when I search for 0 it doesn't return > > > the courses not associated with any event? (if not, I'll have to > > > migrate my events so that I don't use day_of_week = 0 anymore) > > > > > Thanks again! > > > Alex > > > > > On Aug 3, 7:07 pm, Pat Allan <[email protected]> wrote: > > > > Hi Alex > > > > > > A couple of suggestions: > > > > > > * Remove the :type => :integer from the attribute - you're dealing > with > > > an array of integers, not a single one, so this just confuses Sphinx. > TS is > > > smart enough to recognise arrays of integers. > > > > > > * Use actual integers, not integers-as-strings, in your filter. > > > > > > Also, it's worth noting that Sphinx treats NULLs as 0's - so if you > have > > > events attached to a course which have NULL for the day_of_week, it'll > come > > > through as 0. > > > > > > Hope this helps. > > > > > > -- > > > > Pat > > > > > > On 04/08/2010, at 11:47 AM, alex wrote: > > > > > > > Hello, > > > > > > > I'm having a problem searching for attributes with a value equal to > 0. > > > > > > > Here is what happen in irb: > > > > > > >>> Course.search(:with=> {:days=>["2"]}) > > > > > returns the corresponding records > > > > > > >>> Course.search(:with=> {:days=>["0"]}) > > > > > returns all the records, while I'm expecting only a few records to > > > > > be returned. > > > > > > > Here are the pieces of code I think are involved: > > > > > > > course.rb > > > > > has_many :events, :through => :tracks > > > > > ... > > > > > define_index do > > > > > has events(:day_of_week), :as => :days, :type => :integer > > > > > end > > > > > ... > > > > > def self.advanced_search(search, sort = nil) > > > > > with_params = {} > > > > > ... > > > > > if (!search.days.empty?) > > > > > with_params[:days] = search.days > > > > > end > > > > > ... > > > > > search( > > > > > search.keywords, > > > > > :with => with_params, > > > > > :sort_mode => sort_params[:sort_mode], > > > > > :order => sort_params[:order]).collect > > > > > end > > > > > end > > > > > > > Can anybody help me understand why I don't get the expected result? > > > > > > > Thanks! > > > > > Alex > > > > > > > -- > > > > > 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]<thinking-sphinx%[email protected]> > <thinking-sphinx%2Bunsubscribe@ googlegroups.com> > > > . > > > > > 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]<thinking-sphinx%[email protected]> > <thinking-sphinx%2Bunsubscribe@ googlegroups.com> > > > . > > > For more options, visit this group at > > >http://groups.google.com/group/thinking-sphinx?hl=en. > > > > -- > > ------------------------------------------------------------- > > visit my blog athttp://jimlabs.heroku.com > > -- > 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]<thinking-sphinx%[email protected]> > . > For more options, visit this group at > http://groups.google.com/group/thinking-sphinx?hl=en. > > -- ------------------------------------------------------------- visit my blog at http://jimlabs.heroku.com -- 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.
