Your assumptions are correct; a user belongs to one organisation and an organisation has many users and many calendars. Each calendar belongs to only one organisation.
Have rebooted and reindexed and the behaviour remains the same. Additionally, I changed my index method to: @calendars = current_user.organisation.calendars.activeTS And it now lists every non-deleted calendar in the system. So the sphinx_scope seems to be ignoring everything that it's chained onto. No errors that I can see. On Feb 23, 4:56 am, Pat Allan <[email protected]> wrote: > It looks like a user belongs to a single organisation, right? And calendars > belong to organisations... > > So, your search *should* work, because you have the attribute for > organisation_id: it should return calendars for a given organisation. Is it > not doing this? Are there any errors? > > -- > Pat > > On 23/02/2010, at 12:23 PM, Colin wrote: > > > > > 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 > > 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.
