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 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.
