So near and yet so far :/ My Index method:
@calendars = current_user.organisation.calendars.active It displays all of a users' organisations' calendars. My search method: @calendars = current_user.organisation.calendars.activeTS.search params[:query], :star => true So I only want the search to be done on that users' organisations' calendars. The way activeTS is built now, it indexes all calendars that have not been deleted. So I can display calendars that do not belong to that user if I search for them. Any idea how to tweak it to behave the way I want? On Feb 23, 1:09 am, Colin <[email protected]> wrote: > I tried to setup my code the way I had it before. When it was still > all null I realised that it obviously wasn't indexing despite what it > was saying. > One reboot later and it all seems to be working :) > > Thanks for your time and patience guys. > > Regards, > > Colin > > On Feb 22, 11:46 pm, Colin <[email protected]> wrote: > > > > > Here you go:http://pastie.org/837827 > > > On Feb 22, 11:41 pm, Aaron Brethorst <[email protected]> wrote: > > > > Can you perform a ts:index and dump the output into a pastie? > > > > On Feb 22, 2010, at 3:40 PM, Colin wrote: > > > > > Should that would work as the only place is_active is defined is the > > > > line where Aaron suggested to try it? > > > > > Either way, no it doesn't. Still empty. > > > > > On Feb 22, 11:32 pm, Pat Allan <[email protected]> wrote: > > > >> Does a normal search using the attribute work? > > > > >> Calendar.search :with => {:is_active => true} > > > > >> -- > > > >> Pat > > > > >> On 23/02/2010, at 10:24 AM, Colin wrote: > > > > >>> pastie updated to show whole class:http://pastie.org/837509 > > > > >>> define_index do > > > >>> indexes id > > > >>> indexes subject > > > >>> indexes parties > > > > >>> set_property :enable_star => 1 > > > >>> set_property :min_infix_len => 3 > > > > >>> has organisation_id > > > >>> has "deleted_at IS NULL", :as => :is_active, :type => :boolean > > > >>> end > > > > >>> Yep, just stopped, reindexed and restarted there again. Still empty. > > > > >>> On Feb 22, 11:21 pm, Pat Allan <[email protected]> wrote: > > > >>>> What Aaron's been saying has been spot on. > > > > >>>> Colin: can you paste your define_index block here, as it currently > > > >>>> stands? And also, have you restarted Sphinx and re-indexed? An empty > > > >>>> array would suggest Sphinx doesn't know about the new attribute > > > >>>> you've created. > > > > >>>> -- > > > >>>> Pat > > > > >>>> On 23/02/2010, at 9:59 AM, Aaron Brethorst wrote: > > > > >>>>> and your sphinx_scope was defined identically to this? > > > > >>>>> sphinx_scope(:active_ts) { > > > >>>>> { :with => {:is_active => true} } > > > >>>>> } > > > > >>>>> that should work, but i'm no expert unfortunately. > > > > >>>>> On Feb 22, 2010, at 2:55 PM, Colin wrote: > > > > >>>>>> Just to add in the "has "deleted_at IS NULL", :as => :is_active, > > > >>>>>> :type > > > >>>>>> => :boolean" line. > > > > >>>>>> On Feb 22, 10:52 pm, Aaron Brethorst <[email protected]> > > > >>>>>> wrote: > > > >>>>>>> did you modify the define_index block? > > > > >>>>>>> On Feb 22, 2010, at 2:48 PM, Colin wrote: > > > > >>>>>>>> I tried your suggestion and also tried replacing the { > > > >>>>>>>> :conditions => > > > >>>>>>>> ["deleted_at IS NULL"] } with {:conditions => {:deleted_at => > > > >>>>>>>> nil}} > > > >>>>>>>> but in both cases it seems to be returning an empty array. > > > > >>>>>>>> On Feb 22, 10:34 pm, Aaron Brethorst <[email protected]> > > > >>>>>>>> wrote: > > > >>>>>>>>> Pat could certainly speak to this better than I, but I was > > > >>>>>>>>> under the impression that conditions are only used in > > > >>>>>>>>> conjunction with fields that have been marked with 'indexes'. > > > > >>>>>>>>> I was actually doing something similar to what you're trying to > > > >>>>>>>>> accomplish earlier today. Maybe you could do something like the > > > >>>>>>>>> following: > > > > >>>>>>>>> # note: untested code; written in my Mail app > > > > >>>>>>>>> define_index do > > > >>>>>>>>> # all of your existing stuff goes here > > > >>>>>>>>> has "deleted_at IS NULL", :as => :is_active, :type => :boolean > > > >>>>>>>>> end > > > > >>>>>>>>> sphinx_scope(:active_ts) { > > > >>>>>>>>> { :with => {:is_active => true} } > > > > >>>>>>>>> } > > > > >>>>>>>>> On Feb 22, 2010, at 2:21 PM, Colin wrote: > > > > >>>>>>>>>> Thank you for the link. > > > >>>>>>>>>> It fixed the original error but it is now throwing: > > > > >>>>>>>>>> undefined method `keys' for ["deleted_at IS NULL"] > > > > >>>>>>>>>> So would I be right in thinking that I can't use the > > > >>>>>>>>>> ["deleted_at IS > > > >>>>>>>>>> NULL"] syntax to define a condition? > > > > >>>>>>>>>> Regards, > > > > >>>>>>>>>> Colin > > > > >>>>>>>>>> On Feb 22, 8:50 pm, Aaron Brethorst <[email protected]> > > > >>>>>>>>>> wrote: > > > >>>>>>>>>>> Try declaring your sphinx_scopes after define_index. > > > > >>>>>>>>>>>http://brethorsting.com/blog/2010/02/solution-for-undefined-method-sp... > > > > >>>>>>>>>>> On Feb 22, 2010, at 12:46 PM, Colin wrote: > > > > >>>>>>>>>>>> Hi, > > > > >>>>>>>>>>>> I'm getting the above error when I try to declare a > > > >>>>>>>>>>>> sphinx_scope. > > > >>>>>>>>>>>> I've googled around but couldn't find a solution. > > > >>>>>>>>>>>> The model in question can be found > > > >>>>>>>>>>>> here:http://pastie.org/837509 > > > > >>>>>>>>>>>> I've tried it in the syntax shown above and also a direct > > > >>>>>>>>>>>> copy of the > > > >>>>>>>>>>>> named_scope syntax. > > > > >>>>>>>>>>>> Any ideas? > > > > >>>>>>>>>>>> Regards, > > > > >>>>>>>>>>>> Colin > > > > >>>>>>>>>>>> -- > > > >>>>>>>>>>>> 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 > > > >>>>>>>> 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 > > > >>>>> 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 > > > > 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.
