Hey again
Same stuff, the results isn't filtered...
This is still an issue, @Pat - you have any idea what I could try out?
Regards
Den fredag den 20. juni 2014 11.31.53 UTC+2 skrev Daniel Gottschalck:
>
> Hey Roger
>
> Thanks for your tip, ill try that out when I get home and give an update
> if it works or not :-)
>
> Regards
>
> Den fredag den 20. juni 2014 11.25.37 UTC+2 skrev Roger Kind Kristiansen:
>>
>> I'm no expert and I'm not sure what is the problem with your current
>> setup, just pitching in here since I've done something similar. Translating
>> the solution I have to your setup, the way I've done it would look
>> something like this:
>>
>> has "COUNT(CASE courses.is_visible WHEN FALSE THEN 1 ELSE NULL END) > 0",
>> :as => :is_visible, :type => :boolean
>>
>> This attribute would be true only when all courses has is_visible set to
>> true.
>>
>>
>>
>>
>> kl. 22:09:54 UTC+2 onsdag 18. juni 2014 skrev Daniel Gottschalck følgende:
>>>
>>> Hi again
>>>
>>>
>>> Tried with the solution you mentioned before aswell, with the IF = SUM
>>> etc,
>>>
>>> same stuff, nothing happens, and the expected result is not there.
>>>
>>> The SQL query in the log looks as follow:
>>>
>>> Sphinx Query (0.8ms) SELECT * FROM `refinery_wayfinders_project_core`
>>>> WHERE MATCH('felttest') AND `is_visible` = 1 AND `sphinx_deleted` = 0
>>>> LIMIT
>>>> 0, 20
>>>
>>>
>>>
>>> "AND `is_visible`" is incorrect? It doesn't look at
>>> "refinery_wayfinders_courses.is_visible", but sees it as an attribute of
>>> refinery_wayfinders_project........
>>>
>>> has "IF(SUM(refinery_wayfinders_courses.is_visible) =
>>>> COUNT(refinery_wayfinders_courses.is_visible), 1, 0)", as: :is_visible,
>>>> type: :boolean
>>>
>>>
>>>
>>>
>>> Regards
>>>
>>> Den tirsdag den 17. juni 2014 20.56.23 UTC+2 skrev Daniel Gottschalck:
>>>>
>>>> Hey
>>>>
>>>>
>>>> In the website, there is "projects", and "projects" can have "courses".
>>>>
>>>>
>>>> In my project index file, how would I filter on "courses" which
>>>> "is_visible" true?
>>>>
>>>> Im confused on whether to use "has" or "indexes" for a relation model
>>>> boolean value.
>>>>
>>>>
>>>>
>>>> ThinkingSphinx::Index.define 'refinery/wayfinders/project', :with =>
>>>> :active_record do
>>>> indexes :name, sortable: true
>>>> indexes :city
>>>> indexes :description
>>>> indexes courses.name, as: :course_name
>>>>
>>>> indexes courses.is_visible, as: :is_visible <------------------------
>>>> This one?
>>>>
>>>> set_property :group_concat_max_len => 8192
>>>> has zip, external_id
>>>>
>>>>
>>>>
>>>> has courses.is_visible, as: :is_visible, type: :boolean
>>>> <------------------- Or this one?
>>>> end
>>>>
>>>>
>>>> And how would I then filter it in my search_controller? So I only get
>>>> courses which are visible?
>>>>
>>>> @project_search = Refinery::Wayfinders::Project.search(params[:search],
>>>>> :with => { :is_visible => true })
>>>>
>>>>
>>>>
>>>> OR
>>>>
>>>> @project_search = Refinery::Wayfinders::Project.search(params[:search],
>>>>> :include => :is_visible, :conditions => { :is_visible => true })
>>>>
>>>>
>>>>
>>>> Or a third solution?
>>>>
>>>>
>>>> Thanks in advance
>>>>
>>>>
>>>> Regards
>>>>
>>>>>
>>>>
>>>>
--
You received this message because you are subscribed to the Google Groups
"Thinking Sphinx" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To post to this group, send email to [email protected].
Visit this group at http://groups.google.com/group/thinking-sphinx.
For more options, visit https://groups.google.com/d/optout.
